Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ddCOC-0006DK-5S for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 03 Aug 2017 09:25:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ddCOB-0003Si-EQ for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 03 Aug 2017 09:25:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ddCOB-0003SW-4e for pgsql-pkg-debian@postgresql.org; Thu, 03 Aug 2017 09:25:55 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ddCO2-0004PE-V6 for pgsql-pkg-debian@postgresql.org; Thu, 03 Aug 2017 09:25:54 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 3xNPmp00bQz3Dyw; Thu, 3 Aug 2017 11:25:45 +0200 (CEST) Date: Thu, 3 Aug 2017 11:25:45 +0200 From: Christoph Berg To: Ole Streicher Cc: pkg-postgresql-public@lists.alioth.debian.org, pgsql-pkg-debian@postgresql.org Subject: Re: Debian packaging of the q3c and pgsphere extensions Message-ID: <20170803092545.bloxbt6sfsq5j4sd@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Ole Streicher , pkg-postgresql-public@lists.alioth.debian.org, pgsql-pkg-debian@postgresql.org References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="5nuwcrqblov5sy2h" Content-Disposition: inline In-Reply-To: User-Agent: NeoMutt/20170113 (1.7.2) X-Mailing-List: pgsql-pkg-debian List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: Precedence: bulk Sender: pgsql-pkg-debian-owner@postgresql.org --5nuwcrqblov5sy2h Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Re: Ole Streicher 2017-07-31 > I am posting to both lists since I am unsure where the best place is. I > am however not subscribed to any of them, so please keep in Cc for the > moment: Hi Ole, both lists are fine. > As a dependency of the Virtual Observatory "DACHS" package [1], which I > am planning to package, I need to have the "q3c" [2] and "pgsphere" [3] > packages in Debian. All packages already exist in a separate repository > [4]; the initial packaging was done by Florian Rothmaier. Florian was talking to me about these some years back, iirc we were close to getting the packages polished up, but then communication got stuck at some point. Thanks for taking this up again! I'd also like to include the packages on apt.postgresql.org. > However, I am very new to Postgresql extension packaging, and therefore > I would ask to get some useful hints here. Especially: Is there a Debian > policy for postgresql extensions that documents the preferred way for > packaging? pg_buildext(1) and dh_make_pgxs(1) (both from postgresql-server-dev-all) should provide a working skeleton at least for the case of extension-only packages. > A preferred git repository? Or is the Debian Science git > repository OK? Any git repo works. > Are extensions dependent on the postgresql version, and > if yes, how should I create the package to enable smooth transitions? The server major version is encoded in the .so files built and the path names, so they are dependent, yes. > What are the preferred names for the packages? postgresql-9.6-q3c etc. > I would be glad to get some initial startup here (maybe a simple > template or so)? See pg_buildext(1) and dh_make_pgxs(1). The existing https://anonscm.debian.org/cgit/debian-science/packages/q3c.git/ https://anonscm.debian.org/cgit/debian-science/packages/pgsphere.git/ repositories seem mostly fine even by today's packaging standards (maybe some of the extra clutter in debian/rules could be removed), so you should probably go from there. Fwiw, I'd strongly recommend to add a debian/tests/ testsuite (see also pg_buildext(1)), even if it's just a "create extension q3c;", so we have some test coverage. Thanks, Christoph --5nuwcrqblov5sy2h Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlmC7BUACgkQTFprqxLS p64VVg//YF0NAetI6XGKQFpmGrL7OzE3OGf84tVgEPhjEWJXNyDTku43/zQbUPjn PY9JXei4Dwmf/BvmUi73TWOQYk1Bm7O6gr02DLaVisnY7mC3QZ/oJPxFbPnPfmSK y+X7ti9CiOI9LsBjnnKaKlC77M6jxJKUllUlOUyvgkrtpJIne/ktGmwQep82YttH L94ZJkeWCytqmqZHiAg8YwALiU1UTlt/LGL87NjIExw8rDgOBg9WjJuqfQ8ywSss 9tQguyHchXVv3+3D6zF4E2zs9aCqYT/DEQmT6X5dWqfy8OllDDhOyybJcqARx/rT mZ1IrMsCn6YAmlbabgXEo4NY/975ikxIVHmKl9SqUa/xZaPHAzXYazzrSaPDG9hp BheUbOd+alQdHHQPIjYe2qXnWp+xXkOsRJMXxZqKHaaxq3ZKZWjjtgnaEpI6Q3mS n9A0GlfTrS3N/gKF8HCSt5VScVHv3Nijj0pRPcylLBQq/Lv2LoHW3xwSiECZAdIu OpzgjExYYmX3aJv+6upBnjUaIdcBUyXpO8fVBpuyaGBVJj4EVgwE8mMwG03ReAeE QsA66tKeh+a39ci/lhEtd2JITdLdl3HW8lT9ztbvM1ZY7KCSplXs+NN4VdtBQtxk rQhSU0ECoK5VkUykgQ+oDHM9X7Tm+yCm4Nkr2gPqciH3N1I5ZqM= =7GIG -----END PGP SIGNATURE----- --5nuwcrqblov5sy2h--