Re: PostGIS Package for PostgreSQL 11 isn't Available

Thank you for the information.

Respectfully,

Ricardo N Feliciano
@FelicianoTech <https://twitter.com/FelicianoTech> | Feliciano.Tech

On Wed, Jun 6, 2018 at 3:19 PM Christoph Berg <myon(at)debian(dot)org> wrote:

> Re: Ricardo Feliciano 2018-06-06 <CAKR2wJ+G38OeVkP_B+=
> CsS+TrieAiWAoAG-z38wK2GCVPrBPWA(at)mail(dot)gmail(dot)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(at)\(dot)''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(at)\(dot)''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
>