From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id 8/UmIDXgs2GeDwAAgWs5BA (envelope-from ) for ; Sat, 11 Dec 2021 00:18:13 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id jqULGzXgs2GxJgAAbx9fmQ (envelope-from ) for ; Fri, 10 Dec 2021 23:18:13 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 28AFF4D91 for ; Sat, 11 Dec 2021 00:18:13 +0100 (CET) Received: from localhost ([::1]:39788 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mvp9X-0006GE-IB for larch@yhetil.org; Fri, 10 Dec 2021 18:18:11 -0500 Received: from eggs.gnu.org ([209.51.188.92]:47782) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvneQ-0001bi-PD for help-guix@gnu.org; Fri, 10 Dec 2021 16:41:58 -0500 Received: from [2607:f8b0:4864:20::32b] (port=40544 helo=mail-ot1-x32b.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mvneO-0002ml-S4 for help-guix@gnu.org; Fri, 10 Dec 2021 16:41:58 -0500 Received: by mail-ot1-x32b.google.com with SMTP id v15-20020a9d604f000000b0056cdb373b82so10961157otj.7 for ; Fri, 10 Dec 2021 13:41:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=WQdo5ouA97/yRQ70BCtPNhyp7gHs7rAquwwq0bnNY84=; b=oCtS0aV+4KiUrh1A6ihfG28osQ6DSXJTR34ulL0adCBqiOiblPZi86hKfbcuCVsK+I Z60oV2rD25iHhmP9E7YhFcoPYm6UH7tbJPOTJJeidUvuCkZstTujyNSQ6gyyXZRPuNF/ YUvwp007uN4hN3MEr+XrKV6X5ThwPIbD/WmlmpGGqV8xQ7nJByDA2ERjzbQBNScg5JdN 65Z/MT6ocT9rHNUxNLQB1q5+1hg4Iqq9DXtdWrswgnUkbBiWBa+duNKjFgChY1A7IgYD 5PQaQqdlJWI+LlAjoD54qv6zQTCT7aX8XANpA95qzaPOoFrJ4jY6aPa08Pj3uYDVPoJc H2dw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=WQdo5ouA97/yRQ70BCtPNhyp7gHs7rAquwwq0bnNY84=; b=nM2j3npz080ByesMe8Y0xhlqS2yRF0lO5pbv9m4EkJXDMDrbG4ydsNTyd7TfTV7et4 qFfPUxjLxsz2QfgFMJZZuyTC6Bc+MTfZyAsX44rK8Ub7tRiDMro9u6O1AvFqEWIxJq2i WUwuJdc8hpytHaj2pPiV/HKqvko22nFFebRhtJiWKH2unAAw2szAeWBxf9N2yZAexcNj RQkWrUWFHdsEue0dNwau9PC2i3y92yPYE1uGhjqqB5ZRpSaG1EM80bJodvJrOrpqE+8N acH5goKebYXRZl3SXjI1WS20MHyGwznvZoPtxuWnT4fyEMAu7psJPmcmJJnU50fLIZyw 5sqA== X-Gm-Message-State: AOAM532w9PhcYqoUz6YuHrG+JL18DTZKFvz7Z8cDVh2ZaznWfOqe4+/e 6vkRSfbhWa69HCIy6kEP2PA2/8Hje6WCSlVkt7VoZxqGCbU= X-Google-Smtp-Source: ABdhPJxjeejttfvStmwo3lTx5BeWR7OEHLThwaZ9zj2wfCts4/2oACKeV7VJW4GpNLod3izDoUkC95ecG9QtukhOgXE= X-Received: by 2002:a9d:2d81:: with SMTP id g1mr13219511otb.25.1639172515080; Fri, 10 Dec 2021 13:41:55 -0800 (PST) MIME-Version: 1.0 From: Mortimer Cladwell Date: Fri, 10 Dec 2021 16:41:44 -0500 Message-ID: Subject: postgresql client packaging recipe To: help-guix@gnu.org X-Host-Lookup-Failed: Reverse DNS lookup failed for 2607:f8b0:4864:20::32b (failed) Received-SPF: pass client-ip=2607:f8b0:4864:20::32b; envelope-from=mbcladwell@gmail.com; helo=mail-ot1-x32b.google.com X-Spam_score_int: -12 X-Spam_score: -1.3 X-Spam_bar: - X-Spam_report: (-1.3 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-Mailman-Approved-At: Fri, 10 Dec 2021 18:17:59 -0500 Content-Type: text/plain; charset="UTF-8" X-Content-Filtered-By: Mailman/MimeDel 2.1.29 X-BeenThere: help-guix@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-guix-bounces+larch=yhetil.org@gnu.org Sender: "Help-Guix" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1639178293; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=6OSUMWBnxefpvo1RLQxnIxb7UMFhcOV4BQruF6PfXQA=; b=AhxtP5vJjmVOhPI6G6H3JjdzUKOorRo7QVKbnnYKnTbe1gV9m2xeBDebH7A3nIVI2Ih25C JrKI06XQrRb3apskYtgJg7Z+JmI6l6FBxCIcGwtpKiSGI+ghJw8xdY+XbTgIJt9Ah6WAeP U9KX9eu1ptCdsaZk68Hn1pE6tS/TWL3MoYf/gLTA9sKGa3JAqm+GdUu6jFiQye+OLPuxpp w7ssME2ur2a+d+ij3c/DmLx/6hGcup25XQxN5EAMu3SAJC801NVwEQuZLvdMKeDlbXT1jR CYIcc9biB0Bp6JQMeE3ZbmLRTUVDo9v+ILXkfbs9SSAtTCh3HhBiuH0GJOhIaQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1639178293; a=rsa-sha256; cv=none; b=qVwP9UmjLqwl24v6QvFQMAR+3FavJqEa+ZOBjHbVoPUcURduben7zgVXAHCSbKMiyXpGDM jHEMDEZ9NE5+2JOl0pTrOfN7YnEVMuDfbi5SqhbTgb8HLEWfDx+BkhcozhJTMH86vKX5bf XbNDYRJnqEMVGpcxMqzmocRkMkhVKMvnOKMme5KcwWD4DTjPlTUN+ytbvCKbVTyqz/ivIO 6R27TnQM9g+yi3Vlfwf0jawhhtEZt6Ocbb2LFX9xDVEYMLTqtEEO2ycoyHFnTCTpbznYeD uwxqpXnCcUL1oO7Dd61479TBhT0L8DDAp5pqUUzg9x1XSBmdNnM6xDlHSEQVYA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("body hash did not verify") header.d=gmail.com header.s=20210112 header.b=oCtS0aV+; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of "help-guix-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="help-guix-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -1.86 Authentication-Results: aspmx1.migadu.com; dkim=fail ("body hash did not verify") header.d=gmail.com header.s=20210112 header.b=oCtS0aV+; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of "help-guix-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="help-guix-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 28AFF4D91 X-Spam-Score: -1.86 X-Migadu-Scanner: scn1.migadu.com X-TUID: bUaQGwER/O8Y Hi, Postgresql-client is not available in the main repository (server is!). I assumed it was due to the complicated license: https://metadata.ftp-master.debian.org/changelogs//main/p/postgresql-13/postgresql-13_13.4-0+deb11u1_copyright So I wrote a packaging recipe (below) and submitted to nonfree. Was told it might be that no one has gotten around to packaging for main yet. I see the documentation for submitting patches, but not recipe files. Is there a protocol for submitting packaging recipes? guix build succeeds: ...[many successes]... phase `delete-info-dir-file' succeeded after 0.0 seconds starting phase `patch-dot-desktop-files' phase `patch-dot-desktop-files' succeeded after 0.0 seconds starting phase `install-license-files' installing 0 license files from '.' phase `install-license-files' succeeded after 0.0 seconds starting phase `reset-gzip-timestamps' phase `reset-gzip-timestamps' succeeded after 0.0 seconds starting phase `compress-documentation' phase `compress-documentation' succeeded after 0.0 seconds successfully built /gnu/store/fqmsg116ycbxyvns6wd09cwk2a6nyqis-postgresql-client-13.4.drv /gnu/store/w9gswswv5qxc84nyq5n7zkicygsb0rrq-postgresql-client-13.4 Tested and functional on Debian. Thanks Mortimer ---------------------------------------------------------------------------------------- (define-module (gnu packages postgresql-client) #:use-module (guix packages) #:use-module ((guix licenses) #:prefix license:) #:use-module (guix download) #:use-module (guix build-system gnu) #:use-module (gnu packages) #:use-module (gnu packages autotools) #:use-module (gnu packages guile) #:use-module (gnu packages base) #:use-module (gnu packages pkg-config) #:use-module (gnu packages readline) #:use-module (gnu packages texinfo)) (define-public postgresql-client (package (name "postgresql-client") (version "13.4") (source (origin (method url-fetch) (uri " http://deb.debian.org/debian/pool/main/p/postgresql-13/postgresql-13_13.4.orig.tar.bz2 ") (sha256 (base32 "1kf0gcsrl5n25rjlvkh87aywmn28kbwvakm5c7j1qpr4j01y34za")))) (build-system gnu-build-system) (arguments `()) (native-inputs `(("autoconf" ,autoconf) ("automake" ,automake) ("pkg-config" ,pkg-config) ("texinfo" ,texinfo))) (inputs `(("readline" ,readline) ("zlib" ,(@ (gnu packages compression) zlib)))) (propagated-inputs `()) (synopsis "Front-end programs for PostgreSQL 13") (description "This package contains client and administrative programs for PostgreSQL: these are the interactive terminal client psql and programs for creating and removing users and databases.") (home-page "https://www.postgresql.org/docs/13/reference-client.html") (license license:gpl3+)))