[postgis-users] make failing postgis-3.1.3dev for CENTOS 7

Fri Sep 3 15:35:13 PDT 2021

The key piece for MVT is protobuf.  Which versions do you have of each of these?

--with-protobuf-inc=/usr/local/include/google/protobuf-c --with-protobufdir=/apps/protobuf/protobuf-c-master/protobuf-c -with-protobuf-lib=/usr/local/lib  

You might be better off using PKG_CONFIG_PATH instead of passing in explicitly. I run mine with pkg-config

Like so:

export PKG_CONFIG_PATH="/usr/local/lib/pkgconfig "

and take out the protobuf variables from you configure.

As far as MVT support in PostGIS RHEL7 3.1 libraries.  The problem is RHEL7 ships with a lower protobuf than is required for PostGIS 3.1.  In PostGIS 3.1 we upped the protobuf-c requirement to  1.1.0 because of too many complaints of awful performance with lower versions.

It looks like this issue has already been ticketed on yum.postgresql.org and marked as in progress.  You could just keep tabs on that or write to mailing list (pgsql-pkg-yum at listspostgresql.org ) – subscribe here - https://lists.postgresql.org/   to find out more.

Yum ticket here – I’m pasting here cause requires login to see.

https://redmine.postgresql.org/issues/6679

Details of ticket below:

PostGIS 3.1 not compiled with protobuf-c support

Added by Drew Lund <https://redmine.postgresql.org/users/5209>  22 days <https://redmine.postgresql.org/projects/pgrpms/activity?from=2021-08-12>  ago. Updated 18 days <https://redmine.postgresql.org/projects/pgrpms/activity?from=2021-08-16>  ago. 

Status:

In Progress

Priority:

Normal

Assignee:

Devrim Gündüz <https://redmine.postgresql.org/users/32> 

Category:

Package improvement

Target version:

PostgreSQL 13 <https://redmine.postgresql.org/versions/103> 

Start date:

2021-08-12

Due date:

% Done:

0%

Estimated time:

Platform:

Resolution:

  _____  

Quote <https://redmine.postgresql.org/issues/6679/quoted>  

Description

Calling the ST_AsMVTGeom function after a fresh PostgreSQL 13 with PostGIS 3.1 install on RHEL7 results in the following error:

ERROR:  ST_AsMVTGeom: Compiled without protobuf-c support

SQL state: XX000

This issue was previously addressed for PostGIS versions 2.4 and 2.5 here: https://redmine.postgresql.org/issues/4390

History

Quote <https://redmine.postgresql.org/issues/6679/quoted?journal_id=29213>  #1 <https://redmine.postgresql.org/issues/6679#note-1>  

Updated by Devrim Gündüz <https://redmine.postgresql.org/users/32>  18 days <https://redmine.postgresql.org/projects/pgrpms/activity?from=2021-08-16>  ago 

*	Status changed from New to In Progress

Hi,

Upstream requires 1.1.0, which is not available on RHEL 7:

  _____  

checking protobuf-c version... configure: error: "Old protobuf-c release found but 1.1.0 is required. You can disable MVT and Geobuf support using --without-protobuf"

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Raj Talati
Sent: Tuesday, August 31, 2021 5:04 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] make failing postgis-3.1.3dev for CENTOS 7

Hello,

I was able to run the configure finally with the option to download proj/geos and other latest packages to get support for MVT. Not sure what I am missing here ? Is there a full RPM package for 3.1.3 with MVT Support  for CENTOS 7 ? as normal PostGIS yum install doesn't allow MVT functions . 

make had same error 

So ran make - i  ( To ignore error ) 

make check gives the same error so i guess will not work . 

Ran configure with options  : 

./configure --with-pgconfig=/usr/pgsql-13/bin/pg_config --with-geosconfig=/apps/geos/geos-3.9.1/tools/geos-config --with-protobuf-inc=/usr/local/include/google/protobuf-c --with-protobufdir=/apps/protobuf/protobuf-c-master/protobuf-c -with-protobuf-lib=/usr/local/lib  --with-gdalconfig=/usr/gdal32/bin/gdal-config

config.log last few lines output 

#define PGSQL_LOCALEDIR "/usr/pgsql-13/share/locale"
#define HAVE_LIBPQ 1
#define POSTGIS_PGSQL_VERSION 130
#define POSTGIS_PGSQL_HR_VERSION 13.0
#define HAVE_LIBXML_TREE_H 1
#define HAVE_LIBXML_PARSER_H 1
#define HAVE_LIBXML_XPATH_H 1
#define HAVE_LIBXML_XPATHINTERNALS_H 1
#define HAVE_LIBXML2 1
#define POSTGIS_LIBXML2_VERSION "2.9.1"
#define HAVE_LIBGEOS_C 1
#define POSTGIS_GEOS_VERSION 39
#define ENABLE_NLS 1
#define HAVE_GETTEXT 1
#define HAVE_DCGETTEXT 1
#define POSTGIS_PROJ_VERSION 81
#define HAVE_LIBPROJ 1
#define HAVE_LIBPROTOBUF_C 1
#define HAVE_PROTOBUF_C_VERSION 1
#define HAVE_LIBPROTOBUF 1
#define LIBPROTOBUF_VERSION 1004000
#define PARANOIA_LEVEL 0
#define POSTGIS_VERSION "3.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
#define POSTGIS_LIB_VERSION "3.1.3dev"
#define POSTGIS_BUILD_DATE "2021-08-31 19:43:37"
#define POSTGIS_SCRIPTS_VERSION "3.1.3dev"
#define POSTGIS_RASTER_WARN_ON_TRUNCATION 0
#define POSTGIS_GDAL_VERSION 32
#define HAVE_GDAL_H 1
#define HAVE_OGR_API_H 1
#define HAVE_CPL_CONV_H 1
#define HAVE_CXX11 1
#define HAVE_WAGYU 1

configure: exit 0

v # make check
! find . -name '*.c' -o -name '*.h' -o -name '*.proto' | \
        grep -v lwin_wkt_lex.c | \
        grep -v lwin_wkt_parse | \
        grep -v lookup3 | \
        grep -v vector_tile.pb-c | \
        grep -v postgis/sqldefines.h | \
        grep -v deps/ | \
        xargs grep -n '[[:space:]]$'
/usr/bin/perl utils/repo_revision.pl <http://repo_revision.pl> 
fatal: Not a git repository (or any parent up to mount point /apps)
Stopping at filesystem boundary (GIT_DISCOVERY_ACROSS_FILESYSTEM not set).
Can't determine revision from git log
Not updating existing rev file at fd0cef4
for s in liblwgeom libpgcommon postgis regress raster topology  loader utils doc extensions deps; do \
        echo "---- Making all in ${s}"; \
        make -C ${s} all || exit 1; \
done;
---- Making all in liblwgeom
make[1]: Entering directory `/apps/postgis/postgis-3.1.3dev/liblwgeom'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/apps/postgis/postgis-3.1.3dev/liblwgeom'
---- Making all in libpgcommon
make[1]: Entering directory `/apps/postgis/postgis-3.1.3dev/libpgcommon'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/apps/postgis/postgis-3.1.3dev/libpgcommon'
---- Making all in postgis
make[1]: Entering directory `/apps/postgis/postgis-3.1.3dev/postgis'
/usr/bin/protoc-c --c_out=. vector_tile.proto
vector_tile.proto:21:13: Expected "required", "optional", or "repeated".
vector_tile.proto:21:30: Missing field number.
make[1]: *** [vector_tile.pb-c.c] Error 1
make[1]: Leaving directory `/apps/postgis/postgis-3.1.3dev/postgis'
make: *** [all] Error 1

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210903/e01d5ef1/attachment.html>