public inbox for [email protected]
help / color / mirror / Atom feedPG10 postgis24 + gdal on RHEL6
12+ messages / 2 participants
[nested] [flat]
* PG10 postgis24 + gdal on RHEL6
@ 2017-11-29 10:03 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
0 siblings, 1 reply; 12+ messages in thread
From: Justin Pryzby @ 2017-11-29 10:03 UTC (permalink / raw)
To: pgsql-pkg-yum
Just wanted to point out that the GDAL package seems to be unavailable for PG10
for (at least) centos6.
Deploying a new customer, our ansible deployment script is failing like so:
TASK: [redhat_pgsql | Install postgresql-server] ******************************
failed: [new.gta] => {"changed": true, "cmd": ["yum", "-y", "install", "postgresql10-server", "postgresql10-docs", "postgresql10-contrib", "pgfincore10", "pg_repack10", "pgtune", "proj-nad", "libpqxx", "libpqxx-devel", "postgis24_10", "postgis24_10-client", "postgis24_10-docs", "postgis24_10-utils"], "delta": "0:00:13.078998", "end": "2017-11-29 19:55:36.754333", "item": "", "rc": 1, "start": "2017-11-29 19:55:23.675335"}
stderr: Error: Package: postgis24_10-2.4.2-1.rhel6.x86_64 (pgdg10)
Requires: gdal-libs >= 1.9.0
Thanks,
Justin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PG10 postgis24 + gdal on RHEL6
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
@ 2017-11-29 10:22 ` Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
0 siblings, 1 reply; 12+ messages in thread
From: Devrim Gündüz @ 2017-11-29 10:22 UTC (permalink / raw)
To: Justin Pryzby <[email protected]>; pgsql-pkg-yum
Hi Justin,
On Wed, 2017-11-29 at 04:03 -0600, Justin Pryzby wrote:
> Just wanted to point out that the GDAL package seems to be unavailable for
> PG10 for (at least) centos6.
Apologies for the inconvenience. I just pushed the packages to repo. They will
be available 1 hour later.
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] 12+ messages in thread
* libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
@ 2017-12-07 21:02 ` Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
0 siblings, 1 reply; 12+ messages in thread
From: Justin Pryzby @ 2017-12-07 21:02 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Wed, Nov 29, 2017 at 10:22:48AM +0000, Devrim Gündüz wrote:
> On Wed, 2017-11-29 at 04:03 -0600, Justin Pryzby wrote:
> > Just wanted to point out that the GDAL package seems to be unavailable for
> > PG10 for (at least) centos6.
>
> Apologies for the inconvenience. I just pushed the packages to repo. They will
> be available 1 hour later.
It looks like maybe the same thing is true for libgeotiff.x86_64 ?
..which I see is available @pgdg94, and 96, but not 10.
Thanks
Justin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
@ 2017-12-08 19:33 ` Justin Pryzby <[email protected]>
2017-12-14 19:15 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
0 siblings, 2 replies; 12+ messages in thread
From: Justin Pryzby @ 2017-12-08 19:33 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
I compared lists of RPMs available for PG10 vs PG96 for RHEL6 and found that
these seem to be missing for PG10. That primarily affects new installs, users
who upgrade from PG10 are likely to have the PG96 PGDG repo still.
libgeotiff proj libpqxx?
On Thu, Dec 07, 2017 at 03:02:45PM -0600, Justin Pryzby wrote:
> On Wed, Nov 29, 2017 at 10:22:48AM +0000, Devrim Gündüz wrote:
> > On Wed, 2017-11-29 at 04:03 -0600, Justin Pryzby wrote:
> > > Just wanted to point out that the GDAL package seems to be unavailable for
> > > PG10 for (at least) centos6.
> >
> > Apologies for the inconvenience. I just pushed the packages to repo. They will
> > be available 1 hour later.
>
> It looks like maybe the same thing is true for libgeotiff.x86_64 ?
> ..which I see is available @pgdg94, and 96, but not 10.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
@ 2017-12-14 19:15 ` Justin Pryzby <[email protected]>
1 sibling, 0 replies; 12+ messages in thread
From: Justin Pryzby @ 2017-12-14 19:15 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
Just checking in. Our deployment scripts intending to use PG10 currently fail
unless I install PGDG PG96 repo rpm.
On Fri, Dec 08, 2017 at 01:33:13PM -0600, Justin Pryzby wrote:
> I compared lists of RPMs available for PG10 vs PG96 for RHEL6 and found that
> these seem to be missing for PG10. That primarily affects new installs, users
> who upgrade from PG10 are likely to have the PG96 PGDG repo still.
>
> libgeotiff proj libpqxx?
>
> On Thu, Dec 07, 2017 at 03:02:45PM -0600, Justin Pryzby wrote:
> > On Wed, Nov 29, 2017 at 10:22:48AM +0000, Devrim Gündüz wrote:
> > > On Wed, 2017-11-29 at 04:03 -0600, Justin Pryzby wrote:
> > > > Just wanted to point out that the GDAL package seems to be unavailable for
> > > > PG10 for (at least) centos6.
> > >
> > > Apologies for the inconvenience. I just pushed the packages to repo. They will
> > > be available 1 hour later.
> >
> > It looks like maybe the same thing is true for libgeotiff.x86_64 ?
> > ..which I see is available @pgdg94, and 96, but not 10.
--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
@ 2017-12-15 03:05 ` Devrim Gündüz <[email protected]>
2017-12-15 03:26 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-16 19:01 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
1 sibling, 2 replies; 12+ messages in thread
From: Devrim Gündüz @ 2017-12-15 03:05 UTC (permalink / raw)
To: Justin Pryzby <[email protected]>; +Cc: pgsql-pkg-yum
Hi,
On Fri, 2017-12-08 at 13:33 -0600, Justin Pryzby wrote:
> I compared lists of RPMs available for PG10 vs PG96 for RHEL6 and found that
> these seem to be missing for PG10. That primarily affects new installs,
> users
> who upgrade from PG10 are likely to have the PG96 PGDG repo still.
>
> libgeotiff
Pushed to repos. They will be available in next 20 mins.
> proj
Please grab this from EPEL:
https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/
> libpqxx?
It is already in the repo (5.0.1-2)
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] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
@ 2017-12-15 03:26 ` Justin Pryzby <[email protected]>
2017-12-15 06:16 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
1 sibling, 1 reply; 12+ messages in thread
From: Justin Pryzby @ 2017-12-15 03:26 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote:
> On Fri, 2017-12-08 at 13:33 -0600, Justin Pryzby wrote:
> > I compared lists of RPMs available for PG10 vs PG96 for RHEL6 and found that
> > these seem to be missing for PG10. That primarily affects new installs,
> > users
> > who upgrade from PG10 are likely to have the PG96 PGDG repo still.
> >
> > libgeotiff
>
> Pushed to repos. They will be available in next 20 mins.
Thank you!
> > proj
> Please grab this from EPEL:
> https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/
You're right, thanks.
> > libpqxx?
> It is already in the repo (5.0.1-2)
Not for centos6 (nor RHEL6) ?
https://yum.postgresql.org/10/redhat/rhel-6-x86_64/
Justin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
2017-12-15 03:26 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
@ 2017-12-15 06:16 ` Devrim Gündüz <[email protected]>
0 siblings, 0 replies; 12+ messages in thread
From: Devrim Gündüz @ 2017-12-15 06:16 UTC (permalink / raw)
To: Justin Pryzby <[email protected]>; +Cc: pgsql-pkg-yum
Hi,
On Thu, 2017-12-14 at 21:26 -0600, Justin Pryzby wrote:
> > > libpqxx?
> >
> > It is already in the repo (5.0.1-2)
>
> Not for centos6 (nor RHEL6) ?
> https://yum.postgresql.org/10/redhat/rhel-6-x86_64/
Sorry, I thought it was RHEL 7. libpqxx 5 does not compile on RHEL 6. Please
grab libpqxx 4.0.1 from EPEL.
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] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
@ 2017-12-16 19:01 ` Justin Pryzby <[email protected]>
2017-12-18 14:56 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
1 sibling, 1 reply; 12+ messages in thread
From: Justin Pryzby @ 2017-12-16 19:01 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote:
> > proj
>
> Please grab this from EPEL:
>
> https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/
For centos6, I think there's an issue with the version of proj in EPEL combined
with postgis10_24:
[pryzbyj@db ~]$ yum list --showdu proj
...
Installed Packages
proj.x86_64 4.7.0-1.el6 @epel
Available Packages
proj.i686 4.7.0-1.el6 epel
proj.x86_64 4.7.0-1.el6 epel
proj.x86_64 4.8.0-2.rhel6 pgdg96
[pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head
BEGIN
SET
DO
CREATE FUNCTION
psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:94: ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: pj_get_spheroid_defn
psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:107: ERROR: current transaction is aborted, commands ignored until end of transaction block
[pryzbyj@db ~]$ nm -D /usr/lib64/libproj.so.0.6.6 |grep pj_get_spheroid_defn || echo NOT FOUND
NOT FOUND
proj 4.8 from PGDG96 works ok:
[pryzbyj@db ~]$ psql 3rivers -qf /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql && echo OK
OK
[pryzbyj@db ~]$ sudo yum list --showduplicates postgis24_10{,-client,-utils} libgeotiff gdal-libs libspatialite proj
Loaded plugins: etckeeper, fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.scalabledns.com
* epel: mirror.chpc.utah.edu
* extras: repos.forethought.net
* ius: ord.mirror.rackspace.com
* updates: repos.forethought.net
Installed Packages
gdal-libs.x86_64 1.9.2-8.rhel6 @pgdg10
libgeotiff.x86_64 1.4.0-1.rhel6 @pgdg96
libspatialite.x86_64 2.4.0-0.6.RC4.el6 @epel
postgis24_10.x86_64 2.4.2-1.rhel6 @pgdg10
postgis24_10-client.x86_64 2.4.2-1.rhel6 @pgdg10
postgis24_10-utils.x86_64 2.4.2-1.rhel6 @pgdg10
proj.x86_64 4.8.0-2.rhel6 @pgdg96
Available Packages
gdal-libs.x86_64 1.9.2-8.rhel6 pgdg10
gdal-libs.x86_64 1.9.2-8.rhel6 pgdg96
libgeotiff.i686 1.2.5-6.el6 epel
libgeotiff.x86_64 1.2.5-6.el6 epel
libgeotiff.x86_64 1.4.0-1.rhel6 pgdg96
libspatialite.i686 2.4.0-0.6.RC4.el6 epel
libspatialite.x86_64 2.4.0-0.6.RC4.el6 epel
postgis24_10.x86_64 2.4.1-1.rhel6 pgdg10
postgis24_10.x86_64 2.4.2-1.rhel6 pgdg10
postgis24_10-client.x86_64 2.4.1-1.rhel6 pgdg10
postgis24_10-client.x86_64 2.4.2-1.rhel6 pgdg10
postgis24_10-utils.x86_64 2.4.1-1.rhel6 pgdg10
postgis24_10-utils.x86_64 2.4.2-1.rhel6 pgdg10
proj.i686 4.7.0-1.el6 epel
proj.x86_64 4.7.0-1.el6 epel
proj.x86_64 4.8.0-2.rhel6 pgdg96
Thanks for your support in this and in building RPMs.
Justin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
2017-12-16 19:01 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
@ 2017-12-18 14:56 ` Justin Pryzby <[email protected]>
2017-12-19 21:30 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-19 21:45 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
0 siblings, 2 replies; 12+ messages in thread
From: Justin Pryzby @ 2017-12-18 14:56 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Sat, Dec 16, 2017 at 01:01:01PM -0600, Justin Pryzby wrote:
> On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote:
>
> > > proj
> >
> > Please grab this from EPEL:
> >
> > https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/
>
> For centos6, I think there's an issue with the version of proj in EPEL combined
> with postgis10_24:
>
> [pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head
...
> psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:94: ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: pj_get_spheroid_defn
I meant to also say:
I think that indicates a missing dependency version in the postgis package. I
know that in debian, this kind of thing is handled by dpkg-shlibdeps.
--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
2017-12-16 19:01 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-18 14:56 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
@ 2017-12-19 21:30 ` Justin Pryzby <[email protected]>
1 sibling, 0 replies; 12+ messages in thread
From: Justin Pryzby @ 2017-12-19 21:30 UTC (permalink / raw)
To: Devrim Gündüz <[email protected]>; +Cc: pgsql-pkg-yum
On Mon, Dec 18, 2017 at 08:56:35AM -0600, Justin Pryzby wrote:
> On Sat, Dec 16, 2017 at 01:01:01PM -0600, Justin Pryzby wrote:
> > On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote:
> >
> > > > proj
> > >
> > > Please grab this from EPEL:
> > >
> > > https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/
> >
> > For centos6, I think there's an issue with the version of proj in EPEL combined
> > with postgis10_24:
> >
> > [pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head
> ...
> > psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:94: ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: pj_get_spheroid_defn
>
> I meant to also say:
> I think that indicates a missing dependency version in the postgis package. I
> know that in debian, this kind of thing is handled by dpkg-shlibdeps.
I was doing another deployment (ansible) and again ran into same issue (I
think):
TASK: [legacy_appserver | create postgis environment] *************************
failed: [new.gta] => {"failed": true, "item": ""}
msg: Database query failed: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: geod_init
gdal-libs.x86_64 1.9.2-8.rhel6 @pgdg10
geos.x86_64 3.5.0-1.rhel6 @pgdg10
geos36.x86_64 3.6.2-2.rhel6 @pgdg10
geos36-devel.x86_64 3.6.2-2.rhel6 @pgdg10
libgeotiff.x86_64 1.4.0-1.rhel6 @pgdg96
postgis24_10.x86_64 2.4.2-3.rhel6 @pgdg10
proj.x86_64 4.8.0-2.rhel6 @pgdg10
libspatialite.x86_64 2.4.0-0.6.RC4.el6 @epel
I see:
https://trac.osgeo.org/postgis/ticket/3142
[pryzbyj@gta-mtx-telsa ~]$ yum list --showdu proj
Loaded plugins: etckeeper, fastestmirror, security
Loading mirror speeds from cached hostfile
* base: centos.mirror.ndchost.com
* epel: mirror.sjc02.svwh.net
* extras: mirror.lax.hugeserver.com
* ius: mirror.team-cymru.org
* updates: mirrors.usc.edu
Installed Packages
proj.x86_64 4.8.0-2.rhel6 @pgdg10
Available Packages
proj.i686 4.7.0-1.el6 epel
proj.x86_64 4.7.0-1.el6 epel
proj.x86_64 4.8.0-2.rhel6 pgdg10
proj.x86_64 4.8.0-2.rhel6 pgdg96
I was able to work around by doing:
sudo yum downgrade postgis24_10{,-client,-utils}-2.4.2-1.rhel6
Was the postgis24_10 built against a proj from centos7 or not available in
repo?
--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Re: PG10 postgis24 + gdal on RHEL6 Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
2017-12-16 19:01 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-18 14:56 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
@ 2017-12-19 21:45 ` Devrim Gündüz <[email protected]>
1 sibling, 0 replies; 12+ messages in thread
From: Devrim Gündüz @ 2017-12-19 21:45 UTC (permalink / raw)
To: Justin Pryzby <[email protected]>; +Cc: pgsql-pkg-yum
Hi,
On Mon, 2017-12-18 at 08:56 -0600, Justin Pryzby wrote:
> I meant to also say: I think that indicates a missing dependency version in
> the postgis package
I bite the bullet, and (I think) I got rid of all proj-4.8.0 dependency in RHEL
7 repos. RHEL 6 needs a bit more work, I am on it.
FWIW, PGDG repos will include GDAL, libgeotiff and OGDI, which uses proj49 RPMs
that we provide.
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] 12+ messages in thread
end of thread, other threads:[~2017-12-19 21:45 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-11-29 10:03 PG10 postgis24 + gdal on RHEL6 Justin Pryzby <[email protected]>
2017-11-29 10:22 ` Devrim Gündüz <[email protected]>
2017-12-07 21:02 ` libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-08 19:33 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-14 19:15 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 03:05 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
2017-12-15 03:26 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-15 06:16 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[email protected]>
2017-12-16 19:01 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-18 14:56 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-19 21:30 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Justin Pryzby <[email protected]>
2017-12-19 21:45 ` Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Devrim Gündüz <[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