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:00:09 -0500 Message-ID: <87y361ueue.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]:44255) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gz6Je-0002Wl-A1 for help-guix@gnu.org; Wed, 27 Feb 2019 16:00:35 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gz6Jc-00059E-T9 for help-guix@gnu.org; Wed, 27 Feb 2019 16:00:34 -0500 Received: from mail-pg1-x544.google.com ([2607:f8b0:4864:20::544]:37460) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1gz6Jc-00054U-Er for help-guix@gnu.org; Wed, 27 Feb 2019 16:00:32 -0500 Received: by mail-pg1-x544.google.com with SMTP id q206so8544299pgq.4 for ; Wed, 27 Feb 2019 13:00:29 -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 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=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