From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?UTF-8?Q?G=C3=A1bor?= Boskovits Subject: bug#32712: Error running "create extension postgis" Date: Wed, 12 Sep 2018 09:40:28 +0200 Message-ID: References: <8736uf9zx2.fsf@sturm.com.au> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="000000000000f9c9210575a7b45c" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:38013) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fzzls-0007GO-1o for bug-guix@gnu.org; Wed, 12 Sep 2018 03:41:09 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fzzlm-0005Ht-Nm for bug-guix@gnu.org; Wed, 12 Sep 2018 03:41:07 -0400 Received: from debbugs.gnu.org ([208.118.235.43]:33507) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fzzlm-0005Hn-Je for bug-guix@gnu.org; Wed, 12 Sep 2018 03:41:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1fzzlm-0008R7-HI for bug-guix@gnu.org; Wed, 12 Sep 2018 03:41:02 -0400 Sender: "Debbugs-submit" Resent-Message-ID: In-Reply-To: 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: Julien Lepiller Cc: 32712@debbugs.gnu.org --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--