Re: PostGIS does not work with Postgresql installation
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 writes: > Hello, > > Gary Johnson 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
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 writes: > Hello, > > Gary Johnson 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
Hello, Gary Johnson 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
PostGIS does not work with Postgresql installation
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
