[postgis-devel] Centos 6?

[Justin Pryzby]

On Sun, Oct 06, 2019 at 10:48:00AM -0500, Justin Pryzby wrote:
> On Sun, Oct 06, 2019 at 08:15:45AM -0700, Paul Ramsey wrote:
> > I tried to build on Centos 6 (only 32bit VM I had around) and was a little surprised to find we don’t build there. 
> 
> I was literally in the middle of mailing Devrim about packaging postgis25 for
> centos6 :)
> 
> > Firstly because of some pragmas that don’t exist on older GCC, and then (didn’t get past this issue) because the postgis_proc_upgrade.util file doesn’t even run. Super weird. Anyways, I don’t perceive centos 6 as being soooo old, so wondering about that.
> > 
> > syntax error at ../utils/postgis_proc_upgrade.pl line 273, near "s/CREATE AGGREGATE/CREATE OR REPLACE AGGREGATE/r”
> 
> Looks like that's a perl 5.14 feature:
> https://www.perl.com/pub/2011/05/new-features-of-perl-514-non-destructive-substitution.html/
> 
> And centos6 has:
> $ perl --version
> This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi
> 
> I think you could just write:
> my $pg12_def = $def;
> $pg12def =~ s/CREATE AGGREGATE/CREATE OR REPLACE AGGREGATE/r;

Confirmed I was able to compile postgis3 on centos6 like so:

        my $pg12_def = $def;
        $pg12_def =~ s/CREATE AGGREGATE/CREATE OR REPLACE AGGREGATE/;

sudo yum install geos36-devel proj49-devel json-c12-devel gdal-devel hdf5-devel # hdf5-devel-1.8.5.patch1-10.el6.x86_64
time ./configure --with-pgconfig=/usr/pgsql-11/bin/pg_config --with-geosconfig=/usr/geos36/bin/geos-config --with-projdir=/usr/proj49 --with-gdalconfig=/usr/bin/gdal-config && make

Postgis25 has the #pragma issue but not the perl issue.

Justin