PostGIS does not work with Postgresql installation

PostGIS does not work with Postgresql installation

[Gary Johnson]

Hi Guix,

  I need to install the PostGIS spatial extensions into my local
PostgreSQL database. However, due to our unique packaging setup,
PostgreSQL cannot find the PostGIS extension directory.

Here is the error I'm getting from within a psql session:

-------------------------------------------------------------
postgres=# CREATE EXTENSION postgis;

ERROR: could not open extension control file
"/gnu/store/1ybw54pgin4b59czcppybzlk6jkqnxik-postgresql-10.6/share/extension/postgis.control":
No such file or directory
-------------------------------------------------------------

This file is actually installed here:

/gnu/store/nx9lyaia3z8ilxm1z80f7rhg1j3ka1j8-postgis-2.4.4/share/extension/postgis.control

So...the issue is, of course, that Guix is installing PostGIS into its
own directory under /gnu/store rather then into the PostgreSQL install
directory, which is how other package managers do it.

Unfortunately, I can't find any environment variables that I can set to
tell PostgreSQL where to look from the postgis.control file. Instead, it
looks like the *postgis* package under gnu/packages/geo.scm needs to be
rewritten to correctly write out symlinks into the postgresql install
directory.

I don't currently have the Guix programming chops to make this happen.
Perhaps someone else on this mailing list can help?

Thanks,
  Gary

Re: PostGIS does not work with Postgresql installation

[Gábor Boskovits]

Hello,

Gary Johnson <lambdatronic@gmail.com> ezt írta (időpont: 2019. febr.
5., K, 19:22):
>
> Hi Guix,
>
>   I need to install the PostGIS spatial extensions into my local
> PostgreSQL database. However, due to our unique packaging setup,
> PostgreSQL cannot find the PostGIS extension directory.
>

The fix for this is currently on staging, see:
http://issues.guix.info/issue/32297.
If needed you can cherry-pick it from there, but this may trigger lot
of rebuilds.

> Here is the error I'm getting from within a psql session:
>
> -------------------------------------------------------------
> postgres=# CREATE EXTENSION postgis;
>
> ERROR: could not open extension control file
> "/gnu/store/1ybw54pgin4b59czcppybzlk6jkqnxik-postgresql-10.6/share/extension/postgis.control":
> No such file or directory
> -------------------------------------------------------------
>
> This file is actually installed here:
>
> /gnu/store/nx9lyaia3z8ilxm1z80f7rhg1j3ka1j8-postgis-2.4.4/share/extension/postgis.control
>
> So...the issue is, of course, that Guix is installing PostGIS into its
> own directory under /gnu/store rather then into the PostgreSQL install
> directory, which is how other package managers do it.
>
> Unfortunately, I can't find any environment variables that I can set to
> tell PostgreSQL where to look from the postgis.control file. Instead, it
> looks like the *postgis* package under gnu/packages/geo.scm needs to be
> rewritten to correctly write out symlinks into the postgresql install
> directory.
>
> I don't currently have the Guix programming chops to make this happen.
> Perhaps someone else on this mailing list can help?
>
> Thanks,
>   Gary
>

Thank you for your report.

Best regards,
g_bor

Re: PostGIS does not work with Postgresql installation

[Gary Johnson]

Thanks for the pointer to Julien's Postgresql extensions patch.
(http://issues.guix.info/issue/32297) I have a couple of follow-up
questions:

1. Is there any timeline for when this change will be merged into
   master? It seems generally useful to the community since currently
   you can't use any custom Postgresql extensions with the database
   server, and Julien's patch looked pretty complete.

2. How do I go about cherry-picking commits from different guix branches
   into the guix branch that I am building from? How will this interact
   with future calls to guix pull? Do I need to maintain a separate
   branch that merges guix master and guix staging (or commits I
   cherry-pick therefrom)?

Thanks for your help. I really need to get PostGIS operational ASAP.

~Gary

Gábor Boskovits <boskovits@gmail.com> writes:

> Hello,
>
> Gary Johnson <lambdatronic@gmail.com> ezt írta (időpont: 2019. febr.
> 5., K, 19:22):
>>
>> Hi Guix,
>>
>>   I need to install the PostGIS spatial extensions into my local
>> PostgreSQL database. However, due to our unique packaging setup,
>> PostgreSQL cannot find the PostGIS extension directory.
>>
>
> The fix for this is currently on staging, see:
> http://issues.guix.info/issue/32297.
> If needed you can cherry-pick it from there, but this may trigger lot
> of rebuilds.
>
>> Here is the error I'm getting from within a psql session:
>>
>> -------------------------------------------------------------
>> postgres=# CREATE EXTENSION postgis;
>>
>> ERROR: could not open extension control file
>> "/gnu/store/1ybw54pgin4b59czcppybzlk6jkqnxik-postgresql-10.6/share/extension/postgis.control":
>> No such file or directory
>> -------------------------------------------------------------
>>
>> This file is actually installed here:
>>
>> /gnu/store/nx9lyaia3z8ilxm1z80f7rhg1j3ka1j8-postgis-2.4.4/share/extension/postgis.control
>>
>> So...the issue is, of course, that Guix is installing PostGIS into its
>> own directory under /gnu/store rather then into the PostgreSQL install
>> directory, which is how other package managers do it.
>>
>> Unfortunately, I can't find any environment variables that I can set to
>> tell PostgreSQL where to look from the postgis.control file. Instead, it
>> looks like the *postgis* package under gnu/packages/geo.scm needs to be
>> rewritten to correctly write out symlinks into the postgresql install
>> directory.
>>
>> I don't currently have the Guix programming chops to make this happen.
>> Perhaps someone else on this mailing list can help?
>>
>> Thanks,
>>   Gary
>>
>
> Thank you for your report.
>
> Best regards,
> g_bor

Re: PostGIS does not work with Postgresql installation

[Gary Johnson]

Hi Guix,

Please disregard my last message. It looks like Julien's patch that adds
#:extension-packages to the operating-system's postgresql-service
function was already merged into master. Excellent!

~Gary

Gábor Boskovits <boskovits@gmail.com> writes:

> Hello,
>
> Gary Johnson <lambdatronic@gmail.com> ezt írta (időpont: 2019. febr.
> 5., K, 19:22):
>>
>> Hi Guix,
>>
>>   I need to install the PostGIS spatial extensions into my local
>> PostgreSQL database. However, due to our unique packaging setup,
>> PostgreSQL cannot find the PostGIS extension directory.
>>
>
> The fix for this is currently on staging, see:
> http://issues.guix.info/issue/32297.
> If needed you can cherry-pick it from there, but this may trigger lot
> of rebuilds.
>
>> Here is the error I'm getting from within a psql session:
>>
>> -------------------------------------------------------------
>> postgres=# CREATE EXTENSION postgis;
>>
>> ERROR: could not open extension control file
>> "/gnu/store/1ybw54pgin4b59czcppybzlk6jkqnxik-postgresql-10.6/share/extension/postgis.control":
>> No such file or directory
>> -------------------------------------------------------------
>>
>> This file is actually installed here:
>>
>> /gnu/store/nx9lyaia3z8ilxm1z80f7rhg1j3ka1j8-postgis-2.4.4/share/extension/postgis.control
>>
>> So...the issue is, of course, that Guix is installing PostGIS into its
>> own directory under /gnu/store rather then into the PostgreSQL install
>> directory, which is how other package managers do it.
>>
>> Unfortunately, I can't find any environment variables that I can set to
>> tell PostgreSQL where to look from the postgis.control file. Instead, it
>> looks like the *postgis* package under gnu/packages/geo.scm needs to be
>> rewritten to correctly write out symlinks into the postgresql install
>> directory.
>>
>> I don't currently have the Guix programming chops to make this happen.
>> Perhaps someone else on this mailing list can help?
>>
>> Thanks,
>>   Gary
>>
>
> Thank you for your report.
>
> Best regards,
> g_bor