{ fetchFromGitHub, lib, stdenv, perl, libxml2, postgresql, postgresqlTestHook, geos, proj, gdalMinimal, json_c, pkg-config, file, protobufc, libiconv, libxslt, docbook5, cunit, pcre2, postgresqlTestExtension, jitSupport, llvm, buildPostgresqlExtension, autoconf, automake, libtool, which, }: let gdal = gdalMinimal; in buildPostgresqlExtension (finalAttrs: { pname = "postgis"; version = "3.5.0"; outputs = [ "out" "doc" ]; src = fetchFromGitHub { owner = "postgis"; repo = "postgis"; rev = "${finalAttrs.version}"; hash = "sha256-wh7Lav2vnKzGWuSvvMFvAaGV7ynD+KgPsFUgujdtzlA="; }; buildInputs = [ libxml2 geos proj gdal json_c protobufc pcre2.dev ] ++ lib.optional stdenv.hostPlatform.isDarwin libiconv; nativeBuildInputs = [ autoconf automake libtool perl pkg-config which ] ++ lib.optional jitSupport llvm; dontDisableStatic = true; nativeCheckInputs = [ postgresqlTestHook cunit libxslt ]; postgresqlTestUserOptions = "LOGIN SUPERUSER"; failureHook = "postgresqlStop"; # postgis config directory assumes /include /lib from the same root for json-c library env.NIX_LDFLAGS = "-L${lib.getLib json_c}/lib"; setOutputFlags = false; preConfigure = '' ./autogen.sh ''; configureFlags = [ "--with-gdalconfig=${gdal}/bin/gdal-config" "--with-jsondir=${json_c.dev}" "--disable-extension-upgrades-install" ]; postConfigure = '' mkdir -p $out/bin # postgis' build system assumes it is being installed to the same place as postgresql, and looks # for the postgres binary relative to $PREFIX. We gently support this system using an illusion. ln -s ${postgresql}/bin/postgres $out/bin/postgres ''; makeFlags = [ "PERL=${perl}/bin/perl" ]; doCheck = stdenv.hostPlatform.isLinux; preCheck = '' substituteInPlace doc/postgis-out.xml --replace-fail "http://docbook.org/xml/5.0/dtd/docbook.dtd" "${docbook5}/xml/dtd/docbook/docbookx.dtd" # The test suite hardcodes it to use /tmp. export PGIS_REG_TMPDIR="$TMPDIR/pgis_reg" ''; # create aliases for all commands adding version information postInstall = '' # Teardown the illusory postgres used for building; see postConfigure. rm $out/bin/postgres for prog in $out/bin/*; do # */ ln -s $prog $prog-${finalAttrs.version} done mkdir -p $doc/share/doc/postgis mv doc/* $doc/share/doc/postgis/ ''; passthru.tests.extension = postgresqlTestExtension { inherit (finalAttrs) finalPackage; sql = let expectedVersion = "${lib.versions.major finalAttrs.version}.${lib.versions.minor finalAttrs.version} USE_GEOS=1 USE_PROJ=1 USE_STATS=1"; in '' CREATE EXTENSION postgis; CREATE EXTENSION postgis_raster; CREATE EXTENSION postgis_topology; select postgis_version(); do $$ begin if postgis_version() <> '${expectedVersion}' then raise '"%" does not match "${expectedVersion}"', postgis_version(); end if; end$$; -- st_makepoint goes through c code select st_makepoint(1, 1); ''; }; meta = with lib; { description = "Geographic Objects for PostgreSQL"; homepage = "https://postgis.net/"; changelog = "https://git.osgeo.org/gitea/postgis/postgis/raw/tag/${finalAttrs.version}/NEWS"; license = licenses.gpl2Plus; maintainers = with maintainers; teams.geospatial.members ++ [ marcweber ]; inherit (postgresql.meta) platforms; }; })