From mboxrd@z Thu Jan 1 00:00:00 1970 From: Gary Johnson Subject: Re: PostGIS does not work with Postgresql installation Date: Wed, 27 Feb 2019 16:16:31 -0500 Message-ID: <87wollue34.fsf@gmail.com> References: <87zhra9kw0.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([209.51.188.92]:47308) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gz6Zg-0006TS-1w for help-guix@gnu.org; Wed, 27 Feb 2019 16:17:10 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gz6Ze-0001zb-2F for help-guix@gnu.org; Wed, 27 Feb 2019 16:17:07 -0500 Received: from mail-pf1-x444.google.com ([2607:f8b0:4864:20::444]:45845) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1gz6Zc-0001sB-90 for help-guix@gnu.org; Wed, 27 Feb 2019 16:17:05 -0500 Received: by mail-pf1-x444.google.com with SMTP id v21so8586883pfm.12 for ; Wed, 27 Feb 2019 13:16:47 -0800 (PST) In-reply-to: List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-guix-bounces+gcggh-help-guix=m.gmane.org@gnu.org Sender: "Help-Guix" To: =?utf-8?Q?G=C3=A1bor?= Boskovits Cc: help-guix 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=C3=A1bor Boskovits writes: > Hello, > > Gary Johnson ezt =C3=ADrta (id=C5=91pont: 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=3D# CREATE EXTENSION postgis; >> >> ERROR: could not open extension control file >> "/gnu/store/1ybw54pgin4b59czcppybzlk6jkqnxik-postgresql-10.6/share/exten= sion/postgis.control": >> No such file or directory >> ------------------------------------------------------------- >> >> This file is actually installed here: >> >> /gnu/store/nx9lyaia3z8ilxm1z80f7rhg1j3ka1j8-postgis-2.4.4/share/extensio= n/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