GNU bug report logs - #32712
Error running "create extension postgis"

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 32712 in the body.
You can then email your comments to 32712 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Ben Sturmfels <ben <at> stumbles.id.au>
To: bug-guix <at> gnu.org
Subject: Error running "create extension postgis"
Date: Wed, 12 Sep 2018 13:07:21 +1000

[Message part 1 (text/plain, inline)]

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

[signature.asc (application/pgp-signature, inline)]

Message #8 received at 32712 <at> debbugs.gnu.org (full text, mbox):

From: Julien Lepiller <julien <at> lepiller.eu>
To: 32712 <at> debbugs.gnu.org
Subject: Re: bug#32712: Error running "create extension postgis"
Date: Wed, 12 Sep 2018 09:11:44 +0200

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.

Le 12 septembre 2018 05:07:21 GMT+02:00, Ben Sturmfels <ben <at> stumbles.id.au> a écrit :
>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

Message #11 received at 32712 <at> debbugs.gnu.org (full text, mbox):

From: Gábor Boskovits <boskovits <at> gmail.com>
To: Julien Lepiller <julien <at> lepiller.eu>
Cc: 32712 <at> debbugs.gnu.org
Subject: Re: bug#32712: Error running "create extension postgis"
Date: Wed, 12 Sep 2018 09:40:28 +0200

[Message part 1 (text/plain, inline)]

Julien Lepiller <julien <at> lepiller.eu> ezt írta (időpont: 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. 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 <ben <at> stumbles.id.au>
> a écrit :
> >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
>
>
>
>

[Message part 2 (text/html, inline)]

Message #16 received at 32712-done <at> debbugs.gnu.org (full text, mbox):

From: Ben Sturmfels <ben <at> sturm.com.au>
To: Gábor Boskovits <boskovits <at> gmail.com>, Julien Lepiller
 <julien <at> lepiller.eu>
Cc: 32712-done <at> debbugs.gnu.org
Subject: Re: bug#32712: Error running "create extension postgis"
Date: Wed, 24 Apr 2019 11:59:11 +1000

[Message part 1 (text/plain, inline)]

On Wed, 12 Sep 2018, Gábor Boskovits wrote:

> Julien Lepiller <julien <at> lepiller.eu> ezt írta (időpont: 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. 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ábor, 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

[signature.asc (application/pgp-signature, inline)]

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.