From debbugs-submit-bounces@debbugs.gnu.org Tue Sep 11 23:07:48 2018 Received: (at submit) by debbugs.gnu.org; 12 Sep 2018 03:07:48 +0000 Received: from localhost ([127.0.0.1]:37644 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fzvVM-0001R7-Go for submit@debbugs.gnu.org; Tue, 11 Sep 2018 23:07:48 -0400 Received: from eggs.gnu.org ([208.118.235.92]:45324) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fzvVL-0001Qv-02 for submit@debbugs.gnu.org; Tue, 11 Sep 2018 23:07:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fzvVF-00029o-0T for submit@debbugs.gnu.org; Tue, 11 Sep 2018 23:07:41 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,T_DKIM_INVALID, UNPARSEABLE_RELAY autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:34974) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fzvVE-00029e-T4 for submit@debbugs.gnu.org; Tue, 11 Sep 2018 23:07:40 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:38064) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fzvVE-00065t-2k for bug-guix@gnu.org; Tue, 11 Sep 2018 23:07:40 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fzvVA-00027B-UM for bug-guix@gnu.org; Tue, 11 Sep 2018 23:07:40 -0400 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]:44855) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fzvVA-00024J-FL for bug-guix@gnu.org; Tue, 11 Sep 2018 23:07:36 -0400 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 01EFB450 for ; Tue, 11 Sep 2018 23:07:34 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Tue, 11 Sep 2018 23:07:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=stumbles.id.au; h=content-type:date:from:message-id:mime-version:subject:to :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=W8ZXUZzz4K4BRjcrf q9N1m4+enmPgLrs5AQX1dW04tk=; b=Paz3J3UiOnKwFfq3aqYD+acuVpSkkYrh4 pqsO60v4wif1LbXS9nEdLqiFRO+2jn5PHfbqYkSjqrImU9kpBsR0wwmYoPDKh557 k9ox8lNT36L88gOl6Cc0ZbwPlsxgXRvR9pUoihHLBZA82IOS6c+8QzBOksSH2cYm F/MfUoYfqSh33ZbZx2UJm4FXWBJbAZbgTw7i1cx8orEScwFxDzU8b2pWEDahyVZZ FCkKSR6nQUml62aREB6GWracZnl85K1h0K22Skwj89ahRYKv38Eq/Ef47l/tfbph I4X3ZS2DT4B+9I3NjLZa7cll+hDbbsvszr82GXjV8YCJkjax+4vpw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:message-id :mime-version:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=W8ZXUZzz4K4BRjcrfq9N1m4+enmPgLrs5AQX1dW04tk=; b=qXG1oeEa bs46mzERsN8mdtTIHhfGC4Xs2ZWAIUIRHQLRhVP9vckZW6bEAKQNYZ2V6QsafLK0 FHXj3A6hEkqGjNdQ9gw0coNkSjbxeY7TRt9C9yRbTGyChVOTzbvfiDO/RGw81g0+ LKpMekq2O28S5PwF+pmhJ/32S2D7q4guqd6zAO61AZoEQTTKW10E/XmDLQCvejTt i0/eu5nPVK+CE5/hI4UZvQn4ASJTBJu+zUOlbCIhNlPkEMCm5LXeI+40p5d0sVDg ZAf9uNK2DEz4Moo0zlhEfUloVNZ4gYT3i0hVNEPgSP3DbEvB5gN4lrqI0hhO9CRt xJjqY3VlU1Emmg== X-ME-Proxy: X-ME-Sender: Received: from localhost (203-214-132-4.perm.iinet.net.au [203.214.132.4]) by mail.messagingengine.com (Postfix) with ESMTPA id 4D58810293 for ; Tue, 11 Sep 2018 23:07:33 -0400 (EDT) Received: from localhost (localhost [local]) by localhost (OpenSMTPD) with ESMTPA id 0cc5c505 for ; Wed, 12 Sep 2018 03:07:30 +0000 (UTC) User-agent: mu4e 1.0; emacs 26.1 From: Ben Sturmfels To: bug-guix@gnu.org Subject: Error running "create extension postgis" Date: Wed, 12 Sep 2018 13:07:21 +1000 Message-ID: <8736uf9zx2.fsf@sturm.com.au> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] [fuzzy] X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -3.8 (---) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -4.8 (----) --=-=-= Content-Type: text/plain Hi Folks, When I attempt to create a database with PostGIS extensions, I get an error "could not open extension control file": $ createdb -O ben testdb $ psql testdb --command="create extension postgis" ERROR: could not open extension control file "/gnu/store/6238qjlc6cl7wld3gykcfj83ajlsrmjd-postgresql-10.5/share/extension/postgis.control": No such file or directory My GuixSD system configuration includes the PostgreSQL service and the PostGIS package, something like this: (packages (cons* ... postgis %base-packages)) (services (cons* ... (postgresql-service) %desktop-services)) If I look in the store, I see "postgis.control" in a number of places, but definitely not in the "postgresql-10.5" directory: $ find /gnu/store -name postgis.control /gnu/store/a9bnyqpxbhskf4vz6p84k4m42li4zqc8-postgis-2.4.4/share/extension/postgis.control /gnu/store/8jimyykpydhppbdbp72zr4z7l0z2fblr-profile/share/extension/postgis.control Regards, Ben --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEPn825zvdanEG+SAhAjwF4snAaPAFAluYgukACgkQAjwF4snA aPAYYw//Sq2n34rGJTXfa1Epy0fyMt7IcfBHkDaioUtNeW+lJijh10ov8tlv/ZIL FI/ENNyDXVH28+9lxNDzDD3pToB4X4m4u6b77ap9nCsfNbXsjWtaXK1SNQDaYwdw 3QSRqFA7NWo5XdL0eEGAon06AxKEhi+U8NesOCdQUt/9n5bcihSwhhAmR2r4eoXB nAxPfEU26ehEK41LRey/rmCLqoaWukjAevemg4nbBTXMmNyR7vNQ4vgwXnCSWeXv 4VrTyhw4mv6ierlZNuPxHVuEVgB+aO4pECgflTtHXyft11+1fjBhvQVt8B5+Q8Sp PoMRJJlPRd7q/HpHvhxoOaIlsjauoCkDgg4JE7uShc1w996Mp6vkNfazbLZVVtJr GMEq2mf1NN3ln4U4EzyQySh1xSz9UBJw+ufGMdsz9NEXJa2XacR7m0sBcgMqxF1v lWb1psxrPIsbu2QdJ6CkVKOp23eS4OkYCgaGTOeFz3o0UOdE7RETnFdFhAOqb0L5 AKlCVpHkt+LF0HGcg5JAxqq9hWW+Ccxg4z4yOoAm8ZLFJwuCMshJz5cF6369fEgc AceL/VmtjKfYpj1WviI8Iwgy3nhYUM8xjpHsCnX29SekwRL3h62px/dxPhgGE2PF srqnMtY22rnE+FHmdPgxUAU+a1q25wNNe7ERI0HPcvTT0A+3a70= =vXIJ -----END PGP SIGNATURE----- --=-=-=-- From debbugs-submit-bounces@debbugs.gnu.org Wed Sep 12 03:14:47 2018 Received: (at 32712) by debbugs.gnu.org; 12 Sep 2018 07:14:47 +0000 Received: from localhost ([127.0.0.1]:37740 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fzzMN-0007hr-1S for submit@debbugs.gnu.org; Wed, 12 Sep 2018 03:14:47 -0400 Received: from lepiller.eu ([89.234.186.109]:55226) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fzzMK-0007hg-PF for 32712@debbugs.gnu.org; Wed, 12 Sep 2018 03:14:45 -0400 Received: from [100.76.227.143] (ghatanothoa.unzane.com [184.105.220.24]) by lepiller.eu (OpenSMTPD) with ESMTPSA id 1d2e5263 (TLSv1.2:ECDHE-RSA-CHACHA20-POLY1305:256:NO) for <32712@debbugs.gnu.org>; Wed, 12 Sep 2018 07:15:52 +0000 (UTC) Date: Wed, 12 Sep 2018 09:11:44 +0200 User-Agent: K-9 Mail for Android In-Reply-To: <8736uf9zx2.fsf@sturm.com.au> References: <8736uf9zx2.fsf@sturm.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Subject: Re: bug#32712: Error running "create extension postgis" To: 32712@debbugs.gnu.org From: Julien Lepiller Message-ID: X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 32712 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Hi, this is a known issue=2E I have sent a patch for that but it wasn't rev= iewed yet=2E Ideally I could also patch the postgresql service to allow spe= cifying extensions=2E I will try to do something about it=2E Le 12 septembre 2018 05:07:21 GMT+02:00, Ben Sturmfels a =C3=A9crit : >Hi Folks, > >When I attempt to create a database with PostGIS extensions, I get an >error "could not open extension control file": > > $ createdb -O ben testdb > $ psql testdb --command=3D"create extension postgis" >ERROR: could not open extension control file >"/gnu/store/6238qjlc6cl7wld3gykcfj83ajlsrmjd-postgresql-10=2E5/share/exte= nsion/postgis=2Econtrol": >No such file or directory > >My GuixSD system configuration includes the PostgreSQL service and the >PostGIS package, something like this: > > (packages (cons* > =2E=2E=2E > postgis > %base-packages)) > > (services (cons* > =2E=2E=2E > (postgresql-service) > %desktop-services)) > >If I look in the store, I see "postgis=2Econtrol" in a number of places, >but definitely not in the "postgresql-10=2E5" directory: > > $ find /gnu/store -name postgis=2Econtrol >/gnu/store/a9bnyqpxbhskf4vz6p84k4m42li4zqc8-postgis-2=2E4=2E4/share/exten= sion/postgis=2Econtrol >/gnu/store/8jimyykpydhppbdbp72zr4z7l0z2fblr-profile/share/extension/postg= is=2Econtrol > >Regards, >Ben From debbugs-submit-bounces@debbugs.gnu.org Wed Sep 12 03:40:47 2018 Received: (at 32712) by debbugs.gnu.org; 12 Sep 2018 07:40:47 +0000 Received: from localhost ([127.0.0.1]:37765 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fzzlX-0008QW-A7 for submit@debbugs.gnu.org; Wed, 12 Sep 2018 03:40:47 -0400 Received: from mail-it0-f66.google.com ([209.85.214.66]:38683) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1fzzlV-0008QI-IF for 32712@debbugs.gnu.org; Wed, 12 Sep 2018 03:40:45 -0400 Received: by mail-it0-f66.google.com with SMTP id p129-v6so1775152ite.3 for <32712@debbugs.gnu.org>; Wed, 12 Sep 2018 00:40:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=v9ggx+RLk6WVBPblJJZuv1J1MiEjg90Q3hYJQh1C6BU=; b=lMJNcAYItIUvnnZg3+KGkgoWHqfelV/hTfjVe85D7/NLAhSI1qC78t6NbpN7sENWoj xQSklNAK1BvjSI6Z/GarYqGXXtGnCUExoVSMQvt9vYRMBFTeaiE9kJtEoz1mlAvnu1sp vNIdrL2zFJTLXwzjLrmy1kVFyK5EUIkEUflX9JLomxrTZWPy4gvv/puEPwYvX73Um9rn lmifAdnMnEn5gpYT/imElcKnmRQkDq8BcQJFwst13yG54IsUCbjKJRxqwYXKBuUOxsUL BTYNQCht2+5VZNbUGtegKHAdqVG0qzQl+of9FXLnMijExE6OCWpqybAfsFs0hlN77YeJ Jhag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=v9ggx+RLk6WVBPblJJZuv1J1MiEjg90Q3hYJQh1C6BU=; b=bhRX8It4o6XbIa3gi2UehE2UMnyKkMRJMnCo/QvJgTKqzLcScnYr2aodAapU8MDPNm DFw5G8SIWAYS4hKZQWtfbkI+IF44wUt4EaWybVQ2uolsiJ8FF6Wm68v0dU5mdkWXBz2y bFeQTyfPi+zbcyodZaKxVY8PyjV2gGM376gTM9C7L7smtjUKJm9TOwvj2GtVVKkdXgMR /MqctJxNgvgyQcu1EMprhkSnj6hAK/nWMwr/0wvaO4/D+IE4JEKa/g6QoRQiY9aEmO8O EqKP2HmEPdWhEFgH5P8cMTqFavImp9UDnaJlVRX5Q+4condLDvMnLuxKELYHen7hpUU3 OMKg== X-Gm-Message-State: APzg51D1ahVuB79T8vJ6TvJsxjBxMqb0Bw0UpiLWICK32O7yAlgggjq4 sLR1ijxmSCMeAqOcEx3O0wMC1wZYAv4hbIiHilfXKkk= X-Google-Smtp-Source: ANB0VdYNRSHWj/635SeApaj+PmJtGdTadA7OzlK7gMx3yqLF9A6B3Me5XJakunarCVsuSs8kzCFRNe6WYorS9TkFgOg= X-Received: by 2002:a24:cd81:: with SMTP id l123-v6mr739485itg.7.1536738039808; Wed, 12 Sep 2018 00:40:39 -0700 (PDT) MIME-Version: 1.0 References: <8736uf9zx2.fsf@sturm.com.au> In-Reply-To: From: =?UTF-8?Q?G=C3=A1bor_Boskovits?= Date: Wed, 12 Sep 2018 09:40:28 +0200 Message-ID: Subject: Re: bug#32712: Error running "create extension postgis" To: Julien Lepiller Content-Type: multipart/alternative; boundary="000000000000f9c9210575a7b45c" X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 32712 Cc: 32712@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) --000000000000f9c9210575a7b45c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Julien Lepiller ezt =C3=ADrta (id=C5=91pont: 2018. sze= pt. 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. > Le 12 septembre 2018 05:07:21 GMT+02:00, Ben Sturmfels > a =C3=A9crit : > >Hi Folks, > > > >When I attempt to create a database with PostGIS extensions, I get an > >error "could not open extension control file": > > > > $ createdb -O ben testdb > > $ psql testdb --command=3D"create extension postgis" > >ERROR: could not open extension control file > > >"/gnu/store/6238qjlc6cl7wld3gykcfj83ajlsrmjd-postgresql-10.5/share/exten= sion/postgis.control": > >No such file or directory > > > >My GuixSD system configuration includes the PostgreSQL service and the > >PostGIS package, something like this: > > > > (packages (cons* > > ... > > postgis > > %base-packages)) > > > > (services (cons* > > ... > > (postgresql-service) > > %desktop-services)) > > > >If I look in the store, I see "postgis.control" in a number of places, > >but definitely not in the "postgresql-10.5" directory: > > > > $ find /gnu/store -name postgis.control > > >/gnu/store/a9bnyqpxbhskf4vz6p84k4m42li4zqc8-postgis-2.4.4/share/extensio= n/postgis.control > > >/gnu/store/8jimyykpydhppbdbp72zr4z7l0z2fblr-profile/share/extension/post= gis.control > > > >Regards, > >Ben > > > > --000000000000f9c9210575a7b45c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Julien Lepiller <julien@lepille= r.eu> ezt =C3=ADrta (id=C5=91pont: 2018. szept. 12., Sze, 9:15):
=
Hi, this is a known= issue. I have sent a patch for that but it wasn't reviewed yet. Ideall= y 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:=C2=A0https:= //issues.guix.info/issue/32297.
I will try to review that, th= is functionality is also important for me.
=C2=A0
Le 12 septembre 2018 05:07:21 GMT+02:00, Ben Sturmfels <ben@stumbles.id.au> a =C3=A9= crit :
>Hi Folks,
>
>When I attempt to create a database with PostGIS extensions, I get an >error "could not open extension control file":
>
>=C2=A0 $ createdb -O ben testdb
>=C2=A0 $ psql testdb --command=3D"create extension postgis" >ERROR:=C2=A0 could not open extension control file
>"/gnu/store/6238qjlc6cl7wld3gykcfj83ajlsrmjd-postgresql-10.5/share= /extension/postgis.control":
>No such file or directory
>
>My GuixSD system configuration includes the PostgreSQL service and the<= br> >PostGIS package, something like this:
>
>=C2=A0 (packages (cons*
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ...
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 postgis
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 %base-packages))
>
>=C2=A0 (services (cons*
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ...
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 (postgresql-service)
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 %desktop-services))
>
>If I look in the store, I see "postgis.control" in a number o= f places,
>but definitely not in the "postgresql-10.5" directory:
>
>=C2=A0 $ find /gnu/store -name postgis.control
>/gnu/store/a9bnyqpxbhskf4vz6p84k4m42li4zqc8-postgis-2.4.4/share/extensi= on/postgis.control
>/gnu/store/8jimyykpydhppbdbp72zr4z7l0z2fblr-profile/share/extension/pos= tgis.control
>
>Regards,
>Ben



--000000000000f9c9210575a7b45c-- From debbugs-submit-bounces@debbugs.gnu.org Tue Apr 23 21:59:30 2019 Received: (at 32712-done) by debbugs.gnu.org; 24 Apr 2019 01:59:30 +0000 Received: from localhost ([127.0.0.1]:54734 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hJ7C5-0006mL-Sz for submit@debbugs.gnu.org; Tue, 23 Apr 2019 21:59:30 -0400 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]:37011) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hJ7C3-0006m6-LE for 32712-done@debbugs.gnu.org; Tue, 23 Apr 2019 21:59:28 -0400 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 8CAED4CC; Tue, 23 Apr 2019 21:59:21 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Tue, 23 Apr 2019 21:59:21 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sturm.com.au; h= from:to:cc:subject:message-id:references:date:in-reply-to :mime-version:content-type; s=fm2; bh=XqvCaXBps8crdHE709kRQW6a8B FogJbA5wkJNLsQIz4=; b=UU9Ts5yE4uB1ZSJYkgFFQZqpICQ2Tw4LCW++wJCYOE 6RypMnWyy8eO3StGJDorZGnN1TSvbyIpS0JjFHcOtCTEfGh52wj3hNs0no1xjqM7 2LO8N3+nmFPKr7EN3pQu1duTjzmPrYsaE9nnYZ961wvxjwRKaIRQ3TE3orLoZ1ov VosLIsWnG9FOxW4nmW1ZyIHjWxuTWt+Wce7lB17FGkrVvOZzPVoocFWs3AQ5hUyI Nd5od3Xix0FLDNAsfA9H+inaMQsyqexHjbJGqXh+qtNSIbjpwhzrA19nMswjXkhq 7Of+UbuOL2fFM6pQjdxd9V7zfnePK/Ovcp2PIZwthHqQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=XqvCaX Bps8crdHE709kRQW6a8BFogJbA5wkJNLsQIz4=; b=cvB3spURofd70NDd3+7ts/ DTvWM867+Z50adCLCNQsZEPRnCpjj+ydFUYUfjVv8IfHMO7ZdeLwhiCpcnaf44O7 E0iBuyYToCwR7Zd3k/lhwwPk8RNqivcfryi+izue77qn0wBmTcREpLrhp58hS0I8 uWbidVP5pLURsHDWzI6jwUJ2G2TlwfMxIfM5W6U1tcUzkdInmjjZCs+w42kdu4OZ Tqoi+qWNM+9dLdy3nBkkFW4wHyu33ics+EYv/2DTg20uKyhSk7mrF2YxtGPpzHFU aCNM9SJ9/Agz1Tx+7vHgMXud3OyOuvVMCryxxRYebVz0Yi+HOuZCBc+MwszENFmw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddrgeelgdehvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefhvffukfhfffgjfgggtgesghdtreertderjeenucfhrhhomhepuegvnhcuufht uhhrmhhfvghlshcuoegsvghnsehsthhurhhmrdgtohhmrdgruheqnecuffhomhgrihhnpe hguhhigidrihhnfhhonecukfhppedvtdefrddvudegrddufedvrddujedtnecurfgrrhgr mhepmhgrihhlfhhrohhmpegsvghnsehsthhurhhmrdgtohhmrdgruhenucevlhhushhtvg hrufhiiigvpedt X-ME-Proxy: Received: from localhost (203-214-132-170.perm.iinet.net.au [203.214.132.170]) by mail.messagingengine.com (Postfix) with ESMTPA id BBA63E4472; Tue, 23 Apr 2019 21:59:18 -0400 (EDT) Received: from localhost (localhost [local]) by localhost (OpenSMTPD) with ESMTPA id 6a51908b; Wed, 24 Apr 2019 01:59:15 +0000 (UTC) From: Ben Sturmfels To: =?utf-8?Q?G=C3=A1bor?= Boskovits , Julien Lepiller Subject: Re: bug#32712: Error running "create extension postgis" Message-ID: <871s1smapb.fsf@sturm.com.au> References: <8736uf9zx2.fsf@sturm.com.au> Date: Wed, 24 Apr 2019 11:59:11 +1000 In-Reply-To: (=?utf-8?Q?=22G=C3=A1bor?= Boskovits"'s message of "Wed, 12 Sep 2018 09:40:28 +0200") User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.2 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" X-Spam-Score: -0.7 (/) X-Debbugs-Envelope-To: 32712-done Cc: 32712-done@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) --=-=-= 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----- --=-=-=-- From unknown Fri Jun 20 07:18:37 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Wed, 22 May 2019 11:24:05 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator