Обсуждение: postgis30 / RH6

Will that combination be built ?  I'm interested in testing the transition on
RH6 for PG11 to 12.  If it's like previous upgrades, I imagine we need to
upgrade the v11 servers to postgis3 in advance of the upgrade, preferably weeks
in advance and not immediately beforehand.

Justin

Hi,

On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
> Will that combination be built ?

No. RHEL 6 is too old to build many of the dependencies.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
> On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
> > Will that combination be built ?  
> 
> No. RHEL 6 is too old to build many of the dependencies.

If I understand right, that means that our postgis-enabled app running PG11/RH6
cannot upgrade to PG12 until first migrating to RH7, then to postgis30.  Is
that right ?

Thanks,
Justin

Could do it the other way? Go to 12/2.5, then to 12/3.0?
P.

> On Sep 13, 2019, at 10:02 AM, Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
>> On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
>>> Will that combination be built ?
>>
>> No. RHEL 6 is too old to build many of the dependencies.
>
> If I understand right, that means that our postgis-enabled app running PG11/RH6
> cannot upgrade to PG12 until first migrating to RH7, then to postgis30.  Is
> that right ?
>
> Thanks,
> Justin
>
>

On Fri, Sep 13, 2019 at 10:17:21AM -0700, Paul Ramsey wrote:
> Could do it the other way? Go to 12/2.5, then to 12/3.0?

That sounds good, but I don't see RPMs for pg12 for any version of postgis:
https://download.postgresql.org/pub/repos/yum/testing/12/redhat/rhel-6-x86_64/

On Sep 13, 2019, at 10:02 AM, Justin Pryzby <pryzby@telsasoft.com> wrote:
> On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
>> On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
>>> Will that combination be built ?  
>> 
>> No. RHEL 6 is too old to build many of the dependencies.
> 
> If I understand right, that means that our postgis-enabled app running PG11/RH6
> cannot upgrade to PG12 until first migrating to RH7, then to postgis30.  Is
> that right ?

On Fri, Sep 13, 2019 at 12:02:49PM -0500, Justin Pryzby wrote:
> On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
> > On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
> > > Will that combination be built ?  
> > 
> > No. RHEL 6 is too old to build many of the dependencies.
> 
> If I understand right, that means that our postgis-enabled app running PG11/RH6
> cannot upgrade to PG12 until first migrating to RH7, then to postgis30.  Is
> that right ?

I should say, that's fine, I just want to make sure I understand.

But it would be somewhat nice if postgis24 were built for pg12, too.  Then I
can start to upgrade everyone in not too long hoping to be the first to hit any
bugs. :)

Thanks,
Justin

On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
> On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
> > Will that combination be built ?  
> 
> No. RHEL 6 is too old to build many of the dependencies.

What dependencies ?  I built PG30/RH6 just now using:
sudo yum install geos36-devel proj49-devel json-c12-devel gdal-devel hdf5-devel # hdf5-devel-1.8.5.patch1-10.el6.x86_64
                         
 

$ rpm -q geos36-devel proj49-devel json-c-devel gdal-devel hdf5-devel
geos36-devel-3.6.3-1.rhel6.1.x86_64
proj49-devel-4.9.3-3.rhel6.1.x86_64
json-c-devel-0.11-13.el6.x86_64
gdal-devel-1.9.2-9.rhel6.x86_64
hdf5-devel-1.8.5.patch1-10.el6.x86_64

Also (I don't know why I didn't ask before) is postgis25 going to be built for
centos6 ?

See also:
https://lists.osgeo.org/pipermail/postgis-devel/2019-October/028110.html

And commits yesterday from Paul, which I think(?) should allow compiling for
RH6.

Now that I've done it already, it seems to me that if these won't be available
on PGDG, I'm likely to compile them locally to allow upgrading to PG12 within a
month rather than over many months.  I guess I'd have to do it for PG11, since
they're already available for PG12.

Justin

> On Oct 7, 2019, at 8:24 AM, Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
>> On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
>>> Will that combination be built ?
>>
>> No. RHEL 6 is too old to build many of the dependencies.
>
> What dependencies ?  I built PG30/RH6 just now using:
> sudo yum install geos36-devel proj49-devel json-c12-devel gdal-devel hdf5-devel #
hdf5-devel-1.8.5.patch1-10.el6.x86_64                           

Maybe libprotobuf-c? But with improved detection added recently we should at least be able to build out support for
ST_AsMVTagainst older libprotobuf-c, and only miss out on ST_AsGeoBuf() which nobody uses anyways. 

P

>
> $ rpm -q geos36-devel proj49-devel json-c-devel gdal-devel hdf5-devel
> geos36-devel-3.6.3-1.rhel6.1.x86_64
> proj49-devel-4.9.3-3.rhel6.1.x86_64
> json-c-devel-0.11-13.el6.x86_64
> gdal-devel-1.9.2-9.rhel6.x86_64
> hdf5-devel-1.8.5.patch1-10.el6.x86_64
>
> Also (I don't know why I didn't ask before) is postgis25 going to be built for
> centos6 ?
>
> See also:
> https://lists.osgeo.org/pipermail/postgis-devel/2019-October/028110.html
>
> And commits yesterday from Paul, which I think(?) should allow compiling for
> RH6.
>
> Now that I've done it already, it seems to me that if these won't be available
> on PGDG, I'm likely to compile them locally to allow upgrading to PG12 within a
> month rather than over many months.  I guess I'd have to do it for PG11, since
> they're already available for PG12.
>
> Justin
>
>

I'm still hoping to hear back about building postgis25/30 under RH6.

On Mon, Oct 07, 2019 at 10:24:21AM -0500, Justin Pryzby wrote:
> On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
> > On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
> > > Will that combination be built ?  
> > 
> > No. RHEL 6 is too old to build many of the dependencies.
> 
> What dependencies ?  I built PG30/RH6 just now using:
> sudo yum install geos36-devel proj49-devel json-c12-devel gdal-devel hdf5-devel #
hdf5-devel-1.8.5.patch1-10.el6.x86_64                          
 
> 
> $ rpm -q geos36-devel proj49-devel json-c-devel gdal-devel hdf5-devel
> geos36-devel-3.6.3-1.rhel6.1.x86_64
> proj49-devel-4.9.3-3.rhel6.1.x86_64
> json-c-devel-0.11-13.el6.x86_64
> gdal-devel-1.9.2-9.rhel6.x86_64
> hdf5-devel-1.8.5.patch1-10.el6.x86_64
> 
> Also (I don't know why I didn't ask before) is postgis25 going to be built for
> centos6 ?
> 
> See also:
> https://lists.osgeo.org/pipermail/postgis-devel/2019-October/028110.html
> 
> And commits yesterday from Paul, which I think(?) should allow compiling for
> RH6.
> 
> Now that I've done it already, it seems to me that if these won't be available
> on PGDG, I'm likely to compile them locally to allow upgrading to PG12 within a
> month rather than over many months.  I guess I'd have to do it for PG11, since
> they're already available for PG12.
> 
> Justin

-- 
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581

Hi,

On Wed, 2019-10-30 at 08:39 -0500, Justin Pryzby wrote:
> I'm still hoping to hear back about building postgis25/30 under RH6.

Given that we now all depend on current GEOS, Proj, GDAL, OGDI, etc releases,
and many of them don't compile under RHEL 6, I am not eager to spend cycles to
maintain newer PostGIS on RHEL 6.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On Wed, Oct 30, 2019 at 11:32:50PM +0000, Devrim Gündüz wrote:
> On Wed, 2019-10-30 at 08:39 -0500, Justin Pryzby wrote:
> > I'm still hoping to hear back about building postgis25/30 under RH6.
> 
> Given that we now all depend on current GEOS, Proj, GDAL, OGDI, etc releases,
> and many of them don't compile under RHEL 6, I am not eager to spend cycles to
> maintain newer PostGIS on RHEL 6.

Please don't waste time on it if it's not trivial, but..

.. you mentioned that it's impossible to build its dependencies, and I asked
which, since I built it myself, using your packages on PGDG.

On Oct 7, 2019, at 8:24 AM, Justin Pryzby <pryzby@telsasoft.com> wrote:
> On Fri, Sep 13, 2019 at 06:00:34PM +0100, Devrim Gündüz wrote:
>> On Sat, 2019-09-07 at 12:52 -0500, Justin Pryzby wrote:
>>> Will that combination be built ?  
>> 
>> No. RHEL 6 is too old to build many of the dependencies.
> 
> What dependencies ?  I built PG30/RH6 just now using:
> sudo yum install geos36-devel proj49-devel json-c12-devel gdal-devel hdf5-devel #
hdf5-devel-1.8.5.patch1-10.el6.x86_64                          
 

Hi,

On Wed, 2019-10-30 at 18:47 -0500, Justin Pryzby wrote:
> Please don't waste time on it if it's not trivial, but..
>
> .. you mentioned that it's impossible to build its dependencies, a

You mean you built GeOS38, Proj62, OGDI41, GDAL30 ? If so, please send me the
patches, I am really willing to apply them and build the RPMs.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On Wed, Oct 30, 2019 at 11:53:29PM +0000, Devrim Gündüz wrote:
> Hi,
> 
> On Wed, 2019-10-30 at 18:47 -0500, Justin Pryzby wrote:
> > Please don't waste time on it if it's not trivial, but..
> > 
> > .. you mentioned that it's impossible to build its dependencies, a
> 
> You mean you built GeOS38, Proj62, OGDI41, GDAL30 ? If so, please send me the
> patches, I am really willing to apply them and build the RPMs.

No; for customers not ready to migrate to centos7, I've been compiling
postgis30 for pg11 and pg12 using the versions of dependencies already
available for centos6.

On Oct 7, 2019, at 8:24 AM, Justin Pryzby <pryzby@telsasoft.com> wrote:
> $ rpm -q geos36-devel proj49-devel json-c-devel gdal-devel hdf5-devel
> geos36-devel-3.6.3-1.rhel6.1.x86_64
> proj49-devel-4.9.3-3.rhel6.1.x86_64
> json-c-devel-0.11-13.el6.x86_64
> gdal-devel-1.9.2-9.rhel6.x86_64
> hdf5-devel-1.8.5.patch1-10.el6.x86_64

sudo yum -y install geos36-devel proj49-devel json-c12-devel gdal-devel hdf5-devel postgresql11-devel
postgresql12-develjson-c-devel # hdf5-devel-1.8.5.patch1-10.el6.x86_64
 
mkdir ~/src ; cd ~/src ; wget https://download.osgeo.org/postgis/source/postgis-3.0.0.tar.gz && tar xf
postgis-3.0.0.tar.gz&& cd postgis-3.0.0
 
time for ver in 11 12; do ./configure --with-pgconfig=/usr/pgsql-$ver/bin/pg_config
--with-geosconfig=/usr/geos36/bin/geos-config--with-projdir=/usr/proj49 --with-gdalconfig=/usr/bin/gdal-config && make
&&sudo make install; done 
 

Hi,

On Wed, 2019-10-30 at 19:02 -0500, Justin Pryzby wrote:
> sudo yum -y install geos36-devel proj49-devel json-c12-devel gdal-devel hdf5-
> devel postgresql11-devel postgresql12-devel json-c-devel # hdf5-devel-
> 1.8.5.patch1-10.el6.x86_64

The recent PostGIS RPMs all depend on GeOS 3.8, and GeOS 3.8 cannot be compiled
on RHEL 6.

FWIW, even RHEL 7 became to be a pain in the neck nowadays, due to the sqlite
version issue.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR