Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQdy3-0000uo-U1 for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 06 Jun 2018 19:19:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQdy2-0002Bq-Hw for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 06 Jun 2018 19:19:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQdy2-0002Bg-Ch for pgsql-pkg-debian@lists.postgresql.org; Wed, 06 Jun 2018 19:19:34 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQdxz-0002Fg-47 for pgsql-pkg-debian@postgresql.org; Wed, 06 Jun 2018 19:19:33 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:147b:4ae0:76e5:bff:fef3:7e00]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 411JQ85HhJz3Dx3; Wed, 6 Jun 2018 21:19:28 +0200 (CEST) Date: Wed, 6 Jun 2018 21:19:28 +0200 From: Christoph Berg To: Ricardo Feliciano Cc: pgsql-pkg-debian@postgresql.org Subject: Re: PostGIS Package for PostgreSQL 11 isn't Available Message-ID: <20180606191928.GA31077@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Ricardo Feliciano , pgsql-pkg-debian@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.5 (2018-04-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Ricardo Feliciano 2018-06-06 > 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