Re: [postgis-users] CREATE EXTENSION postgis fails with "ERROR: could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect"

2016-01-20 Thread Matthew Baker
For what it's worth, the Ubuntu/Debian install was causing this same 
problem from the PostgreSQL APT repository


What was happening was when installing the postgresql-contrib package, 
it was defaulting to the 9.5 version of the package, and so was 
installing another instance of PostgreSQL - so versions 9.4 and 9.5 were 
starting up.


So when I tried to install the postgis extension, it was giving a 
similar error - I believe because it was trying to create the extension 
in the 9.5 version of PG, while PGIS was installed in the 9.4 version


By forcing the version of postgresql-contrib to 9.4, it illeviated the 
problem:


sudo apt-get install postgresql-9.4-postgis-2.1 pgadmin3*postgresql-contrib-9.4*

Not sure if there is an equivalent problem going on...

(I've updated the Ubuntu/Debian instructions here:)

https://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt

-m



On 1/15/2016 7:35 AM, Paul Ramsey wrote:

Thanks for confirming, I've notified the pgdg packager.
P

On Fri, Jan 15, 2016 at 6:25 AM, Paul Edwards  wrote:

Sorry for the spam, but as you suspected:

  yum deplist postgis2_95
bunch of dependencies
dependency: geos >= 3.4.2


On Friday, January 15, 2016 at 9:20:33 AM UTC-5, Paul Edwards wrote:

Was debugging the exact issue yesterday. Updating GEOS to 3.5 did the
trick for me. This is the version of geos provided for in the pgdg95 repo.



On Thursday, January 14, 2016 at 9:13:13 AM UTC-5, Paul Ramsey wrote:

Check the versions of the GEOS rpm you have installed, and also check
the "requires" declarations for the postgis rpm. Probably you'll find
the GEOS rpm is version 3.4 and that the postgis rpm doesn't declare a
dependency for geos 3.5. See if you can track down a GEOS 3.5 rpm.

P

On Thu, Jan 14, 2016 at 2:04 AM, Moti Umansky  wrote:

I have reproduced the issue when installing with yum install from the
internet.

I think there is something wrong with the last version installation on
Oracle Linux (or Red Hat).

Has anyone succeeded to install the last version on Oracle Linux or Red
Hat?



Thanks,

Moti





From: Moti Umansky
Sent: יום א 10 ינואר 2016 18:08
To: 'postgi...@lists.osgeo.org'
Subject: CREATE EXTENSION postgis fails with "ERROR: could not load
library
"/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so:
undefined symbol: GEOSClipByRect"



Hi



I'm trying to install the new 9.5 Postgres version with Postgis 2.2
(downloaded from

https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/)



When I issue "CREATE EXTENSION postgis", I'm getting :



ERROR:  could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so":
/usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect



OS : Oracle Linux 6U7

Postgres version : "PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled
by gcc
(GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit"



I have tried to reproduce the issue on Postgres 9.4.5 downloaded from

https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64.



The issue was not reproduced.



Thanks,

Moti


Powered By Office365

The information contained in this communication is intended solely for
the
use of the individual or entity to whom it is addressed and others
authorized to receive it.
It may contain confidential or legally privileged information.
If you are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in reliance on
the
contents of this information is strictly prohibited and may be
unlawful.
If you have received this communication in error, please notify us
immediately by forwarding this email to mail...@ness.com and then
delete
it from your system.
Ness technologies is neither liable for the proper and complete
transmission
of the information contained in this communication nor for any delay in
its
receipt.

___
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] CREATE EXTENSION postgis fails with "ERROR: could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect"

2016-01-15 Thread Paul Ramsey
Thanks for confirming, I've notified the pgdg packager.
P

On Fri, Jan 15, 2016 at 6:25 AM, Paul Edwards  wrote:
> Sorry for the spam, but as you suspected:
>
>  yum deplist postgis2_95
> bunch of dependencies
> dependency: geos >= 3.4.2
>
>
> On Friday, January 15, 2016 at 9:20:33 AM UTC-5, Paul Edwards wrote:
>>
>> Was debugging the exact issue yesterday. Updating GEOS to 3.5 did the
>> trick for me. This is the version of geos provided for in the pgdg95 repo.
>>
>>
>>
>> On Thursday, January 14, 2016 at 9:13:13 AM UTC-5, Paul Ramsey wrote:
>>>
>>> Check the versions of the GEOS rpm you have installed, and also check
>>> the "requires" declarations for the postgis rpm. Probably you'll find
>>> the GEOS rpm is version 3.4 and that the postgis rpm doesn't declare a
>>> dependency for geos 3.5. See if you can track down a GEOS 3.5 rpm.
>>>
>>> P
>>>
>>> On Thu, Jan 14, 2016 at 2:04 AM, Moti Umansky  wrote:
>>> > I have reproduced the issue when installing with yum install from the
>>> > internet.
>>> >
>>> > I think there is something wrong with the last version installation on
>>> > Oracle Linux (or Red Hat).
>>> >
>>> > Has anyone succeeded to install the last version on Oracle Linux or Red
>>> > Hat?
>>> >
>>> >
>>> >
>>> > Thanks,
>>> >
>>> > Moti
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > From: Moti Umansky
>>> > Sent: יום א 10 ינואר 2016 18:08
>>> > To: 'postgi...@lists.osgeo.org'
>>> > Subject: CREATE EXTENSION postgis fails with "ERROR: could not load
>>> > library
>>> > "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so:
>>> > undefined symbol: GEOSClipByRect"
>>> >
>>> >
>>> >
>>> > Hi
>>> >
>>> >
>>> >
>>> > I'm trying to install the new 9.5 Postgres version with Postgis 2.2
>>> > (downloaded from
>>> >
>>> > https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/)
>>> >
>>> >
>>> >
>>> > When I issue "CREATE EXTENSION postgis", I'm getting :
>>> >
>>> >
>>> >
>>> > ERROR:  could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so":
>>> > /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect
>>> >
>>> >
>>> >
>>> > OS : Oracle Linux 6U7
>>> >
>>> > Postgres version : "PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled
>>> > by gcc
>>> > (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit"
>>> >
>>> >
>>> >
>>> > I have tried to reproduce the issue on Postgres 9.4.5 downloaded from
>>> >
>>> > https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64.
>>> >
>>> >
>>> >
>>> > The issue was not reproduced.
>>> >
>>> >
>>> >
>>> > Thanks,
>>> >
>>> > Moti
>>> >
>>> > 
>>> > Powered By Office365
>>> >
>>> > The information contained in this communication is intended solely for
>>> > the
>>> > use of the individual or entity to whom it is addressed and others
>>> > authorized to receive it.
>>> > It may contain confidential or legally privileged information.
>>> > If you are not the intended recipient you are hereby notified that any
>>> > disclosure, copying, distribution or taking any action in reliance on
>>> > the
>>> > contents of this information is strictly prohibited and may be
>>> > unlawful.
>>> > If you have received this communication in error, please notify us
>>> > immediately by forwarding this email to mail...@ness.com and then
>>> > delete
>>> > it from your system.
>>> > Ness technologies is neither liable for the proper and complete
>>> > transmission
>>> > of the information contained in this communication nor for any delay in
>>> > its
>>> > receipt.
>>> >
>>> > ___
>>> > postgis-users mailing list
>>> > postgi...@lists.osgeo.org
>>> > http://lists.osgeo.org/mailman/listinfo/postgis-users
>>> ___
>>> postgis-users mailing list
>>> postgi...@lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] CREATE EXTENSION postgis fails with "ERROR: could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect"

2016-01-14 Thread Moti Umansky
I have reproduced the issue when installing with yum install from the internet.

I think there is something wrong with the last version installation on Oracle 
Linux (or Red Hat).

Has anyone succeeded to install the last version on Oracle Linux or Red Hat?

Thanks,
Moti


From: Moti Umansky
Sent: יום א 10 ינואר 2016 18:08
To: 'postgis-users@lists.osgeo.org'
Subject: CREATE EXTENSION postgis fails with "ERROR: could not load library 
"/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so: 
undefined symbol: GEOSClipByRect"

Hi

I'm trying to install the new 9.5 Postgres version with Postgis 2.2 (downloaded 
from https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/)

When I issue "CREATE EXTENSION postgis", I'm getting :

ERROR:  could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": 
/usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect

OS : Oracle Linux 6U7
Postgres version : "PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled by gcc 
(GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit"

I have tried to reproduce the issue on Postgres 9.4.5 downloaded from 
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64.

The issue was not reproduced.

Thanks,
Moti

Powered By Office365

The information contained in this communication is intended solely for the use 
of the individual or entity to whom it is addressed and others authorized to 
receive it.
It may contain confidential or legally privileged information.
If you are not the intended recipient you are hereby notified that any 
disclosure, copying, distribution or taking any action in reliance on the 
contents of this information is strictly prohibited and may be unlawful.
If you have received this communication in error, please notify us immediately 
by forwarding this email to mailad...@ness.com and 
then delete it from your system.
Ness technologies is neither liable for the proper and complete transmission of 
the information contained in this communication nor for any delay in its 
receipt.
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] CREATE EXTENSION postgis fails with "ERROR: could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect"

2016-01-14 Thread Paul Ramsey
Check the versions of the GEOS rpm you have installed, and also check
the "requires" declarations for the postgis rpm. Probably you'll find
the GEOS rpm is version 3.4 and that the postgis rpm doesn't declare a
dependency for geos 3.5. See if you can track down a GEOS 3.5 rpm.

P

On Thu, Jan 14, 2016 at 2:04 AM, Moti Umansky  wrote:
> I have reproduced the issue when installing with yum install from the
> internet.
>
> I think there is something wrong with the last version installation on
> Oracle Linux (or Red Hat).
>
> Has anyone succeeded to install the last version on Oracle Linux or Red Hat?
>
>
>
> Thanks,
>
> Moti
>
>
>
>
>
> From: Moti Umansky
> Sent: יום א 10 ינואר 2016 18:08
> To: 'postgis-users@lists.osgeo.org'
> Subject: CREATE EXTENSION postgis fails with "ERROR: could not load library
> "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so:
> undefined symbol: GEOSClipByRect"
>
>
>
> Hi
>
>
>
> I'm trying to install the new 9.5 Postgres version with Postgis 2.2
> (downloaded from
> https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/)
>
>
>
> When I issue "CREATE EXTENSION postgis", I'm getting :
>
>
>
> ERROR:  could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so":
> /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect
>
>
>
> OS : Oracle Linux 6U7
>
> Postgres version : "PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled by gcc
> (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit"
>
>
>
> I have tried to reproduce the issue on Postgres 9.4.5 downloaded from
> https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64.
>
>
>
> The issue was not reproduced.
>
>
>
> Thanks,
>
> Moti
>
> 
> Powered By Office365
>
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it.
> It may contain confidential or legally privileged information.
> If you are not the intended recipient you are hereby notified that any
> disclosure, copying, distribution or taking any action in reliance on the
> contents of this information is strictly prohibited and may be unlawful.
> If you have received this communication in error, please notify us
> immediately by forwarding this email to mailad...@ness.com and then delete
> it from your system.
> Ness technologies is neither liable for the proper and complete transmission
> of the information contained in this communication nor for any delay in its
> receipt.
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] CREATE EXTENSION postgis fails with "ERROR: could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": /usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect"

2016-01-10 Thread Moti Umansky


Hi



I'm trying to install the new 9.5 Postgres version with Postgis 2.2 (downloaded 
from https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.7-x86_64/)



When I issue "CREATE EXTENSION postgis", I'm getting :



ERROR:  could not load library "/usr/pgsql-9.5/lib/postgis-2.2.so": 
/usr/pgsql-9.5/lib/postgis-2.2.so: undefined symbol: GEOSClipByRect



OS : Oracle Linux 6U7

Postgres version : "PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled by gcc 
(GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit"



I have tried to reproduce the issue on Postgres 9.4.5 downloaded from 
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6.7-x86_64.



The issue was not reproduced.



Thanks,

Moti


Powered By Office365

The information contained in this communication is intended solely for the use 
of the individual or entity to whom it is addressed and others authorized to 
receive it.
It may contain confidential or legally privileged information.
If you are not the intended recipient you are hereby notified that any 
disclosure, copying, distribution or taking any action in reliance on the 
contents of this information is strictly prohibited and may be unlawful.
If you have received this communication in error, please notify us immediately 
by forwarding this email to mailad...@ness.com and 
then delete it from your system.
Ness technologies is neither liable for the proper and complete transmission of 
the information contained in this communication nor for any delay in its 
receipt.
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users