Обсуждение: 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