From mboxrd@z Thu Jan  1 00:00:00 1970
Received: from eggs.gnu.org ([2001:4830:134:3::10]:36952)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1fGVxT-0000FZ-3S
	for guix-patches@gnu.org; Wed, 09 May 2018 16:45:08 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1fGVxO-00059D-Ea
	for guix-patches@gnu.org; Wed, 09 May 2018 16:45:07 -0400
Received: from debbugs.gnu.org ([208.118.235.43]:47703)
	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 1fGVxO-000599-BJ
	for guix-patches@gnu.org; Wed, 09 May 2018 16:45:02 -0400
Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2)
	(envelope-from <Debian-debbugs@debbugs.gnu.org>) id 1fGVxO-0007Oy-5B
	for guix-patches@gnu.org; Wed, 09 May 2018 16:45:02 -0400
Subject: [bug#31175] [PATCH] gnu: Add postgis.
Resent-Message-ID: <handler.31175.B31175.152589869028420@debbugs.gnu.org>
Date: Wed, 9 May 2018 22:44:43 +0200
From: Julien Lepiller <julien@lepiller.eu>
Message-ID: <20180509224439.25ce2bc2@lepiller.eu>
In-Reply-To: <20180509085052.575d501b@alma-ubu>
References: <20180416111821.48042726@lepiller.eu>
	<20180509085052.575d501b@alma-ubu>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
List-Id: <guix-patches.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/guix-patches>,
	<mailto:guix-patches-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/guix-patches/>
List-Post: <mailto:guix-patches@gnu.org>
List-Help: <mailto:guix-patches-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/guix-patches>,
	<mailto:guix-patches-request@gnu.org?subject=subscribe>
Errors-To: guix-patches-bounces+kyle=kyleam.com@gnu.org
Sender: "Guix-patches" <guix-patches-bounces+kyle=kyleam.com@gnu.org>
To: 31175@debbugs.gnu.org

Le Wed, 9 May 2018 08:50:52 +0200,
Bj=C3=B6rn H=C3=B6fling <bjoern.hoefling@bjoernhoefling.de> a =C3=A9crit :

> Hu Julien,
>=20
> looking at PostGIS:
>=20
> On Mon, 16 Apr 2018 11:18:21 +0200
> Julien Lepiller <julien@lepiller.eu> wrote:
>=20
> > Hi, here are two patches to add postgis and its dependency gdal. =20
>=20
> +    (description " PostGIS is a spatial database extender for
> PostgreSQL
>=20
> --> There is a space at the beginning. =20
>=20
> Besides of that, this looks good.
>=20
> I have successfully tried shp2pgsql.=20
>=20
> I have not tried and have no idea of how to use Postgresql+PostGIS
> within GuixSD or with a temp database in a Guix container.

I've tried to, but the extension directory is hardcoded. Nix has this
patch for postgresql:

https://github.com/NixOS/nixpkgs/blob/master/pkgs/servers/sql/postgresql/sp=
ecify_pkglibdir_at_runtime.patch

With this, we could add a field to the postgresql configuration that
would take a list of extension packages and set the environment
variable accordingly. The patch only allows one path though. Do you
think it's worth it to adjust it and allow more paths?

>=20
> Thanks,
>=20
> Bj=C3=B6rn