1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
args@{fetchurl, composableDerivation, stdenv, perl, libxml2, postgresql, geos, proj, flex, gdal, json_c, pkgconfig, file, ...}:
/*
### NixOS - usage:
==================
services.postgresql.extraPlugins = [ (pkgs.postgis.override { postgresql = pkgs.postgresql95; }).v_2_2_1 ];
### important Postgis implementation details:
=============================================
Postgis provides a shared library implementing many operations. They are
exposed to the Postgres SQL interpreter by special SQL queries eg:
CREATE FUNCTION [...]
AS '[..]liblwgeom', 'lwhistogram2d_in' LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);
where liblwgeom is the shared library.
Postgis < 1.5 used absolute paths, in NixOS $libdir is always used.
Thus if you want to use postgresql dumps which were created by non NixOS
systems you have to adopt the library path.
### TODO:
=========
the bin commands to have gtk gui:
*/
let
pgDerivationBase = composableDerivation.composableDerivation {} ( fix :
let version = fix.fixed.version; in {
name = "postgis-${version}";
src = fetchurl {
url = "http://postgis.refractions.net/download/postgis-${fix.fixed.version}.tar.gz";
inherit (fix.fixed) sha256;
};
# don't pass these vars to the builder
removeAttrs = ["hash" "sql_comments" "sql_srcs"];
preConfigure = ''
configureFlags="--datadir=$out/share --datarootdir=$out/share --bindir=$out/bin"
makeFlags="PERL=${perl}/bin/perl datadir=$out/share pkglibdir=$out/lib bindir=$out/bin"
'';
# create aliases for all commands adding version information
postInstall = ''
sql_srcs=$(for sql in ${builtins.toString fix.fixed.sql_srcs}; do echo -n "$(find $out -iname "$sql") "; done )
for prog in $out/bin/*; do # */
ln -s $prog $prog-${version}
done
cp -r doc $out
'';
buildInputs = [libxml2 postgresql geos proj perl];
sql_comments = "postgis_comments.sql";
meta = {
description = "Geographic Objects for PostgreSQL";
homepage = "http://postgis.refractions.net";
license = stdenv.lib.licenses.gpl2;
maintainers = [stdenv.lib.maintainers.marcweber];
platforms = stdenv.lib.platforms.linux;
};
});
pgDerivationBaseNewer = pgDerivationBase.merge (fix: {
src = fetchurl {
url = "http://download.osgeo.org/postgis/source/postgis-${builtins.toString fix.fixed.version}.tar.gz";
inherit (fix.fixed) sha256;
};
});
in rec {
v_2_2_1 = pgDerivationBaseNewer.merge ( fix : {
version = "2.2.1";
sha256 = "02gsi1cm63kf0r7881444lrkzdjqhhpz9a5zav3al0q24nq01r8g";
sql_srcs = ["postgis.sql" "spatial_ref_sys.sql"];
builtInputs = [gdal json_c pkgconfig];
dontDisableStatic = true;
preConfigure = ''
sed -i 's@/usr/bin/file@${file}/bin/file@' configure
configureFlags="$configureFlags --with-gdalconfig=${gdal}/bin/gdal-config --with-jsondir=${json_c}"
'';
postConfigure = ''
sed -i "s|@mkdir -p \$(DESTDIR)\$(PGSQL_BINDIR)||g ;
s|\$(DESTDIR)\$(PGSQL_BINDIR)|$prefix/bin|g
" \
"raster/loader/Makefile";
sed -i "s|\$(DESTDIR)\$(PGSQL_BINDIR)|$prefix/bin|g
" \
"raster/scripts/python/Makefile";
'';
});
}
|