public inbox for [email protected]
help / color / mirror / Atom feedpg11 centos7 postgis24 broken due to libgeos
6+ messages / 2 participants
[nested] [flat]
* pg11 centos7 postgis24 broken due to libgeos
@ 2018-10-18 16:40 Justin Pryzby <[email protected]>
2018-10-29 13:17 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Justin Pryzby @ 2018-10-18 16:40 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On a brand new centos7 VM, built earlier this week, I just attempted to upgrade
to PG11:
[pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt
could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /usr/pgsql-11/lib/postgis-2.4.so: undefined symbol: geod_polygon_init
[pryzbyj@database ~]$ rpm -qa |grep geos
geos36-3.6.3-1.rhel7.x86_64
[pryzbyj@database ~]$ rpm -qf /usr/pgsql-11/lib/postgis-2.4.so
postgis24_11-2.4.5-1.rhel7.1.x86_64
I can't see that symbol is available in PGDG 11 repo in geos36 nor 37.
When the package is built which has that symbol, it'll be necessary to have a
versioned dependency.
Justin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg11 centos7 postgis24 broken due to libgeos
2018-10-18 16:40 pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
@ 2018-10-29 13:17 ` Justin Pryzby <[email protected]>
2018-10-29 15:33 ` Re: pg11 centos7 postgis24 broken due to libgeos Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Justin Pryzby @ 2018-10-29 13:17 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
Want to mention that this is still an issue.
On Thu, Oct 18, 2018 at 11:40:19AM -0500, Justin Pryzby wrote:
> On a brand new centos7 VM, built earlier this week, I just attempted to upgrade
> to PG11:
>
> [pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt
> could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /usr/pgsql-11/lib/postgis-2.4.so: undefined symbol: geod_polygon_init
>
> [pryzbyj@database ~]$ rpm -qa |grep geos
> geos36-3.6.3-1.rhel7.x86_64
>
> [pryzbyj@database ~]$ rpm -qf /usr/pgsql-11/lib/postgis-2.4.so
> postgis24_11-2.4.5-1.rhel7.1.x86_64
>
> I can't see that symbol is available in PGDG 11 repo in geos36 nor 37.
>
> When the package is built which has that symbol, it'll be necessary to have a
> versioned dependency.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg11 centos7 postgis24 broken due to libgeos
2018-10-18 16:40 pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 13:17 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
@ 2018-10-29 15:33 ` Devrim Gündüz <[email protected]>
2018-11-14 18:34 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Devrim Gündüz @ 2018-10-29 15:33 UTC (permalink / raw)
To: Justin Pryzby <[email protected]>; +Cc: pgsql-pkg-yum
Hi,
On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote:
> Want to mention that this is still an issue.
Per discussion with upstream, I think I will have to release our GDAL package
to fix this issue. That will likely happen tomorrow.
Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachments:
[application/pgp-signature] signature.asc (833B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg11 centos7 postgis24 broken due to libgeos
2018-10-18 16:40 pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 13:17 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 15:33 ` Re: pg11 centos7 postgis24 broken due to libgeos Devrim Gündüz <[email protected]>
@ 2018-11-14 18:34 ` Justin Pryzby <[email protected]>
2018-11-15 20:50 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Justin Pryzby @ 2018-11-14 18:34 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Mon, Oct 29, 2018 at 03:33:18PM +0000, Devrim Gündüz wrote:
> On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote:
> > Want to mention that this is still an issue.
>
> Per discussion with upstream, I think I will have to release our GDAL package
> to fix this issue. That will likely happen tomorrow.
Checking back about this.
Do you mean you're planning on building an updated GDAL package?
Thanks,
--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg11 centos7 postgis24 broken due to libgeos
2018-10-18 16:40 pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 13:17 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 15:33 ` Re: pg11 centos7 postgis24 broken due to libgeos Devrim Gündüz <[email protected]>
2018-11-14 18:34 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
@ 2018-11-15 20:50 ` Justin Pryzby <[email protected]>
2018-11-15 20:53 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: Justin Pryzby @ 2018-11-15 20:50 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Wed, Nov 14, 2018 at 12:34:40PM -0600, Justin Pryzby wrote:
> On Mon, Oct 29, 2018 at 03:33:18PM +0000, Devrim Gündüz wrote:
> > On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote:
> > > Want to mention that this is still an issue.
> >
> > Per discussion with upstream, I think I will have to release our GDAL package
> > to fix this issue. That will likely happen tomorrow.
I realized that a transition I already did to PG11 was running centos7 and
works just fine (with postgis and all its libs).
The issue appears to be this:
[pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt
could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /usr/pgsql-11/lib/postgis-2.4.so: undefined symbol: geod_polygon_init
[pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so|grep proj
libproj.so.0 => /lib64/libproj.so.0 (0x00007f5ef6681000)
[pryzbyj@database ~]$ rpm -qf /lib64/libproj.so.0
proj-4.8.0-4.el7.x86_64
[pryzbyj@database ~]$ rpm -qa |grep proj
proj-nad-4.8.0-4.el7.x86_64
proj49-4.9.3-3.rhel7.x86_64
proj-4.8.0-4.el7.x86_64
On the working server, libproj.so.0 finds proj49 (both servers have both
libraries installed).
[pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so |grep proj
libproj.so.12 => /usr/proj49/lib/libproj.so.12 (0x00007f219c649000)
The postgis24_11 pacakge is pulling in proj/epel, and the PGDG proj49 doesn't
satisfy the dependency.
I worked around the problem on one of the failing servers by copying an older
postgis RPM out of /var/cache on the working server:
package postgis24_11-2.4.5-1.rhel7.1.x86_64 (which is newer than postgis24_11-2.4.5-1.rhel7.x86_64) is already installed
Hope that helps.
Justin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg11 centos7 postgis24 broken due to libgeos
2018-10-18 16:40 pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 13:17 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 15:33 ` Re: pg11 centos7 postgis24 broken due to libgeos Devrim Gündüz <[email protected]>
2018-11-14 18:34 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-11-15 20:50 ` Re: pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
@ 2018-11-15 20:53 ` Justin Pryzby <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Justin Pryzby @ 2018-11-15 20:53 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Thu, Nov 15, 2018 at 02:50:19PM -0600, Justin Pryzby wrote:
> On Wed, Nov 14, 2018 at 12:34:40PM -0600, Justin Pryzby wrote:
> > On Mon, Oct 29, 2018 at 03:33:18PM +0000, Devrim Gündüz wrote:
> > > On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote:
> > > > Want to mention that this is still an issue.
> > >
> > > Per discussion with upstream, I think I will have to release our GDAL package
> > > to fix this issue. That will likely happen tomorrow.
>
> I realized that a transition I already did to PG11 was running centos7 and
> works just fine (with postgis and all its libs).
>
> The issue appears to be this:
>
> [pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt
> could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /usr/pgsql-11/lib/postgis-2.4.so: undefined symbol: geod_polygon_init
>
> [pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so|grep proj
> libproj.so.0 => /lib64/libproj.so.0 (0x00007f5ef6681000)
>
> [pryzbyj@database ~]$ rpm -qf /lib64/libproj.so.0
> proj-4.8.0-4.el7.x86_64
>
> [pryzbyj@database ~]$ rpm -qa |grep proj
> proj-nad-4.8.0-4.el7.x86_64
> proj49-4.9.3-3.rhel7.x86_64
> proj-4.8.0-4.el7.x86_64
>
> On the working server, libproj.so.0 finds proj49 (both servers have both
> libraries installed).
>
> [pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so |grep proj
> libproj.so.12 => /usr/proj49/lib/libproj.so.12 (0x00007f219c649000)
Sorry, what I should have said was:
libproj is libproj.so.12 and not so.0.
Justin
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2018-11-15 20:53 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-18 16:40 pg11 centos7 postgis24 broken due to libgeos Justin Pryzby <[email protected]>
2018-10-29 13:17 ` Justin Pryzby <[email protected]>
2018-10-29 15:33 ` Devrim Gündüz <[email protected]>
2018-11-14 18:34 ` Justin Pryzby <[email protected]>
2018-11-15 20:50 ` Justin Pryzby <[email protected]>
2018-11-15 20:53 ` Justin Pryzby <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox