From mboxrd@z Thu Jan  1 00:00:00 1970
From: Julien Lepiller <julien@lepiller.eu>
Subject: bug#32712: Error running "create extension postgis"
Date: Wed, 12 Sep 2018 09:11:44 +0200
Message-ID: <D7679F77-8D35-4CFF-9801-F0B775A35484@lepiller.eu>
References: <8736uf9zx2.fsf@sturm.com.au>
Mime-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:60504)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1fzzMh-0001tK-1r
	for bug-guix@gnu.org; Wed, 12 Sep 2018 03:15:07 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1fzzMd-00054f-84
	for bug-guix@gnu.org; Wed, 12 Sep 2018 03:15:06 -0400
Received: from debbugs.gnu.org ([208.118.235.43]:33487)
	by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16)
	(Exim 4.71) (envelope-from <Debian-debbugs@debbugs.gnu.org>)
	id 1fzzMd-00054V-3s
	for bug-guix@gnu.org; Wed, 12 Sep 2018 03:15:03 -0400
Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1fzzMc-0007jC-Vf
	for bug-guix@gnu.org; Wed, 12 Sep 2018 03:15:03 -0400
Sender: "Debbugs-submit" <debbugs-submit-bounces@debbugs.gnu.org>
Resent-Message-ID: <handler.32712.B32712.153673648729631@debbugs.gnu.org>
In-Reply-To: <8736uf9zx2.fsf@sturm.com.au>
List-Id: Bug reports for GNU Guix <bug-guix.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/bug-guix>,
	<mailto:bug-guix-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/bug-guix/>
List-Post: <mailto:bug-guix@gnu.org>
List-Help: <mailto:bug-guix-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/bug-guix>,
	<mailto:bug-guix-request@gnu.org?subject=subscribe>
Errors-To: bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org
Sender: "bug-Guix" <bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org>
To: 32712@debbugs.gnu.org

Hi, this is a known issue=2E I have sent a patch for that but it wasn't rev=
iewed yet=2E Ideally I could also patch the postgresql service to allow spe=
cifying extensions=2E I will try to do something about it=2E

Le 12 septembre 2018 05:07:21 GMT+02:00, Ben Sturmfels <ben@stumbles=2Eid=
=2Eau> a =C3=A9crit :
>Hi Folks,
>
>When I attempt to create a database with PostGIS extensions, I get an
>error "could not open extension control file":
>
>  $ createdb -O ben testdb
>  $ psql testdb --command=3D"create extension postgis"
>ERROR:  could not open extension control file
>"/gnu/store/6238qjlc6cl7wld3gykcfj83ajlsrmjd-postgresql-10=2E5/share/exte=
nsion/postgis=2Econtrol":
>No such file or directory
>
>My GuixSD system configuration includes the PostgreSQL service and the
>PostGIS package, something like this:
>
>  (packages (cons*
>            =2E=2E=2E
>            postgis
>            %base-packages))
>
>  (services (cons*
>            =2E=2E=2E
>            (postgresql-service)
>            %desktop-services))
>
>If I look in the store, I see "postgis=2Econtrol" in a number of places,
>but definitely not in the "postgresql-10=2E5" directory:
>
>  $ find /gnu/store -name postgis=2Econtrol
>/gnu/store/a9bnyqpxbhskf4vz6p84k4m42li4zqc8-postgis-2=2E4=2E4/share/exten=
sion/postgis=2Econtrol
>/gnu/store/8jimyykpydhppbdbp72zr4z7l0z2fblr-profile/share/extension/postg=
is=2Econtrol
>
>Regards,
>Ben