From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ben Sturmfels Subject: bug#32712: Error running "create extension postgis" Date: Wed, 24 Apr 2019 11:59:11 +1000 Message-ID: <871s1smapb.fsf@sturm.com.au> References: <8736uf9zx2.fsf@sturm.com.au> Mime-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([209.51.188.92]:49494) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1hJ7Cg-0002bq-Dr for bug-guix@gnu.org; Tue, 23 Apr 2019 22:00:08 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1hJ7Ce-00068Q-IO for bug-guix@gnu.org; Tue, 23 Apr 2019 22:00:06 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:41192) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1hJ7Ce-00066A-1v for bug-guix@gnu.org; Tue, 23 Apr 2019 22:00:04 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1hJ7Cd-0006nm-01 for bug-guix@gnu.org; Tue, 23 Apr 2019 22:00:03 -0400 Sender: "Debbugs-submit" Resent-To: bug-guix@gnu.org Resent-Message-ID: In-Reply-To: ("=?UTF-8?Q?G=C3=A1bor?= Boskovits"'s message of "Wed, 12 Sep 2018 09:40:28 +0200") List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org Sender: "bug-Guix" To: =?UTF-8?Q?G=C3=A1bor?= Boskovits , Julien Lepiller Cc: 32712-done@debbugs.gnu.org --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On Wed, 12 Sep 2018, G=C3=A1bor Boskovits wrote: > Julien Lepiller ezt =C3=ADrta (id=C5=91pont: 2018. s= zept. 12., Sze, 9:15): > > Hi, this is a known issue. I have sent a patch for that but it wasn't > reviewed yet. Ideally I could also patch the postgresql service to > allow specifying extensions. I will try to do something about it. > > Hello Julien, > > I believe this is the patch: https://issues.guix.info/issue/32297. I > will try to review that, this functionality is also important for me. Thanks Julien and G=C3=A1bor, I see that this patch has now been merged into Guix and the documentation for configuring postgis is available in the info manual under System Configuration, Services, Database Services. I'll close this bug report now. After modifying my service configuration, reconfiguring and running `herd restart postgres`, I was able to create a new database and use the `create extension postgis` command. Folks can see the manual for details, but the configuration change is essentially: (postgresql-service #:extension-packages (list postgis)) Thanks for all your work, I really appreciate this change! Regards, Ben --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEPn825zvdanEG+SAhAjwF4snAaPAFAly/wu8ACgkQAjwF4snA aPBQcQ//dSIyySDpmDwaj0hPvmh42bzuKsJBIn8H31NDM1dDVHEBSoaLDrd+Ngb3 bv1pWKGCebrHc6kZl4L/+15bSbExiUpa37hH6wWBLUI2MpWyM7LdWJmN8JLq0YEA /8MdAWzOIY7jAw7l7Scqchus0SsvMZuhyRwArKzutFitZXCg+YGJkyVqKXYc3bhg 7EWVvHIweX3l9yVGWs1AgwQyktDkTsWl0jSj10VGv7d1YwbGVhj6/tlLtUEFW9en ayEgPBecYevD5P6A9EffjVfsa9dOwTxPtvU8ucdS55yhOEFtxQDWMvaQTdnOEn+N 1nMHA/wZk4Lg1lobXuvgeCOG1iYotzeFR2lTGtlhl450+PUGh2qUwgVSI8Elnl3v v3iJeyyBh7EGnXsud4rhbCnSwozPN+nY8haqITOPh60/+DEjOLN78DEHmSC7JKK7 0yUiViPOafacBcmWvfGRGs1dNZeeyxYNOjMdiY24u1SxG9c1xSfIjNYjOZgOm/zr xzBTw8RpfPakvg6Q/RqQBsf02QSRMigPrI6oxAs8kQMZGu/agX0oPFs7NDbyffhk d8/yns37A9qVhkXyECzBvc/9d1G4PdSfqH7nE77lkL27+vNBCD818CBX7J3bUa7A rC8XoZ14/p7iJeBO/W1hYGVhm/D+BUuCHeuzgpC58TSLKWHQix4= =l7oR -----END PGP SIGNATURE----- --=-=-=--