Re: PostGIS Package for PostgreSQL 11 isn't Available

Re: Ricardo Feliciano 2018-06-06 <CAKR2wJ+G38OeVkP_B+=CsS+TrieAiWAoAG-z38wK2GCVPrBPWA@mail.gmail.com>
> Hey everyone,
> 
> The package `postgresql-11-postgis-2.4` isn't available in the official
> PostgreSQL Apt Repository.
> 
> I've tried locating it when using both:
> 
> "deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main 11"
> "deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg-testing main 11"
> 
> Neither has the package. This is causing the CircleCI Docker image build
> system to fail for those PostgreSQL images.
> 
> Anyway this can be added or is there a suggested alternative? Thank you.

Hi,

the problem is it doesn't build against PG11 if JIT (--with-llvm) is
enabled:

/usr/bin/cpp -traditional-cpp -w -P -I../libpgcommon legacy_minimal.sql.in | grep -v '^#' | \
/usr/bin/perl -lpe "s'MODULE_PATHNAME'\$libdir/postgis-2.4'g;s'@extschema@\.''g" > legacy_minimal.sql
/usr/bin/cpp -traditional-cpp -w -P -I../libpgcommon legacy_gist.sql.in | grep -v '^#' | \
/usr/bin/perl -lpe "s'MODULE_PATHNAME'\$libdir/postgis-2.4'g;s'@extschema@\.''g" > legacy_gist.sql
/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2  -I../libpgcommon  -I/usr/include
-I/usr/include/libxml2   -Wdate-time -D_FORTIFY_SOURCE=2 -fPIC -I. -I./ -I/usr/include/postgresql/11/server
-I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2
-I/usr/include/mit-krb5-flto=thin -emit-llvm -c -o postgis_module.bc postgis_module.c
 
/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2  -I../libpgcommon  -I/usr/include
-I/usr/include/libxml2   -Wdate-time -D_FORTIFY_SOURCE=2 -fPIC -I. -I./ -I/usr/include/postgresql/11/server
-I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2
-I/usr/include/mit-krb5-flto=thin -emit-llvm -c -o lwgeom_accum.bc lwgeom_accum.c
 
/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2  -I../libpgcommon  -I/usr/include
-I/usr/include/libxml2   -Wdate-time -D_FORTIFY_SOURCE=2 -fPIC -I. -I./ -I/usr/include/postgresql/11/server
-I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2
-I/usr/include/mit-krb5-flto=thin -emit-llvm -c -o lwgeom_spheroid.bc lwgeom_spheroid.c
 
postgis_module.c:34:10: fatal error: 'lwgeom_log.h' file not found
#include "lwgeom_log.h"
         ^~~~~~~~~~~~~~
1 error generated.
make[3]: *** [/usr/lib/postgresql/11/lib/pgxs/src/makefiles/../../src/Makefile.global:1009: postgis_module.bc] Fehler
1
make[3]: *** Es wird auf noch nicht beendete Prozesse gewartet....
lwgeom_spheroid.c:42:10: fatal error: 'liblwgeom.h' file not found
#include "liblwgeom.h"
         ^~~~~~~~~~~~~
1 error generated.
make[3]: *** [/usr/lib/postgresql/11/lib/pgxs/src/makefiles/../../src/Makefile.global:1009: lwgeom_spheroid.bc] Fehler
1
lwgeom_accum.c:36:10: fatal error: 'liblwgeom.h' file not found
#include "liblwgeom.h"
         ^~~~~~~~~~~~~
1 error generated.
make[3]: *** [/usr/lib/postgresql/11/lib/pgxs/src/makefiles/../../src/Makefile.global:1009: lwgeom_accum.bc] Fehler 1
make[3]: Verzeichnis „/srv/projects/postgresql/postgis/postgis/postgis“ wird verlassen
make[2]: *** [GNUmakefile:16: all] Fehler 1


This is apparently fixed upstream (http://trac.osgeo.org/postgis/ticket/4060),
but not released yet.

There will be PG11 packages on apt.pg.o (and in Debian) as soon as
there's a release that supports it.

Christoph