[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
PostGIS does not work with Postgresql installation
From: |
Gary Johnson |
Subject: |
PostGIS does not work with Postgresql installation |
Date: |
Tue, 05 Feb 2019 12:59:27 -0500 |
User-agent: |
mu4e 1.0; emacs 26.1 |
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
- PostGIS does not work with Postgresql installation,
Gary Johnson <=