[postgis-users] postgis-users Digest, Vol 189, Issue 3
Q S
qsun7 at hotmail.com
Thu Nov 9 05:40:52 PST 2017
Hi Giuseppe,
Problem solved after recompiling postgis 2.0 for postgresql 9.2
Thanks a lot for your expert advice.
Have a great day
Ben
________________________________
From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of postgis-users-request at lists.osgeo.org <postgis-users-request at lists.osgeo.org>
Sent: Friday, November 3, 2017 3:00 PM
To: postgis-users at lists.osgeo.org
Subject: postgis-users Digest, Vol 189, Issue 3
Send postgis-users mailing list submissions to
postgis-users at lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.osgeo.org/mailman/listinfo/postgis-users
postgis-users Info Page - Open Source Geospatial Foundation<https://lists.osgeo.org/mailman/listinfo/postgis-users>
lists.osgeo.org
A list devoted to the discussion of the use and uses of the PostGIS/PostgreSQL spatial database system. To see the collection of prior postings to the list, visit ...
or, via email, send a message with subject or body 'help' to
postgis-users-request at lists.osgeo.org
You can reach the person managing the list at
postgis-users-owner at lists.osgeo.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."
Today's Topics:
1. Re: postgis-users Digest, Vol 189, Issue 2 (Q S)
2. Re: postgis-users Digest, Vol 189, Issue 2 (Giuseppe Broccolo)
----------------------------------------------------------------------
Message: 1
Date: Thu, 2 Nov 2017 19:15:29 +0000
From: Q S <qsun7 at hotmail.com>
To: "postgis-users at lists.osgeo.org" <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2
Message-ID:
<BLUPR0501MB882706DBA0A6132341AC175E15C0 at BLUPR0501MB882.namprd05.prod.outlook.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi Giuseppe
Apologies for the typo. The error is this:
ERROR: could not find function "gserialized_gidx_geog_overlaps" in /usr/pgsql-9.2/lib/postgis-2.3.so
I have updated at least two hosts without any issues. but this particular one gives me trouble.
All the hosts are linux::
Linux ldevpg-db03.fcc.gov 2.6.18-419.el5 #1 SMP Wed Feb 22 22:40:57 EST 2017 x86_64 x86_64 x86_64 GNU/Linux
I used source code and did the configure/make/make install.
I did try to uninstall the postgis2.3.0 and reinstall it again. But the problem persists.
I even did a database server restart but the problem is still there.
Thanks for you help.
Ben
________________________________
From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of postgis-users-request at lists.osgeo.org <postgis-users-request at lists.osgeo.org>
Sent: Thursday, November 2, 2017 3:00 PM
To: postgis-users at lists.osgeo.org
Subject: postgis-users Digest, Vol 189, Issue 2
Send postgis-users mailing list submissions to
postgis-users at lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.osgeo.org/mailman/listinfo/postgis-users
postgis-users Info Page - Open Source Geospatial Foundation<https://lists.osgeo.org/mailman/listinfo/postgis-users>
lists.osgeo.org
A list devoted to the discussion of the use and uses of the PostGIS/PostgreSQL spatial database system. To see the collection of prior postings to the list, visit ...
postgis-users Info Page - Open Source Geospatial Foundation<https://lists.osgeo.org/mailman/listinfo/postgis-users>
postgis-users Info Page - Open Source Geospatial Foundation<https://lists.osgeo.org/mailman/listinfo/postgis-users>
lists.osgeo.org
A list devoted to the discussion of the use and uses of the PostGIS/PostgreSQL spatial database system. To see the collection of prior postings to the list, visit ...
lists.osgeo.org
Your email address: Your name (optional): You may enter a privacy password below. This provides only mild security, but should prevent others from messing with ...
or, via email, send a message with subject or body 'help' to
postgis-users-request at lists.osgeo.org
You can reach the person managing the list at
postgis-users-owner at lists.osgeo.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."
Today's Topics:
1. Re: upgrade extension error (Giuseppe Broccolo)
----------------------------------------------------------------------
Message: 1
Date: Thu, 2 Nov 2017 00:08:10 +0100
From: Giuseppe Broccolo <g.broccolo.7 at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] upgrade extension error
Message-ID:
<CAFtuf8C=7OBOTYyqgeGkMsnVcm+tpn5bJfSm=sD0F=28q68q2A at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Hi Ben,
2017-10-31 18:48 GMT+01:00 Q S <qsun7 at hotmail.com>:
> postgresql version: 9.2
>
> postgis version: 2.0.
>
>
> 1. install postgis2.3
> 2. login to postgresql database
> 3. alter postgis update to '2.3.0';
>
> ERROR: could not find function "gserialized_gidx_geog_overlaps" in
> /usr/pgsql-9.2/lib/postgis-2.3/so"
>
Could you bring further details about how PostGIS 2.3.0 has been installed?
Through package? On which system (Linux, Windows,...)?
The oddity is the name of the shared object, that should be
"/usr/pgsql-9.2/lib/postgis-2.3.so" (and not "/usr/pgsql-9.2/lib/postgis-2.
3/so").
All the best,
Giuseppe.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171102/aa0318b3/attachment-0001.html>
------------------------------
Subject: Digest Footer
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
postgis-users Info Page - Open Source Geospatial Foundation<https://lists.osgeo.org/mailman/listinfo/postgis-users>
lists.osgeo.org
A list devoted to the discussion of the use and uses of the PostGIS/PostgreSQL spatial database system. To see the collection of prior postings to the list, visit ...
postgis-users Info Page - Open Source Geospatial Foundation<https://lists.osgeo.org/mailman/listinfo/postgis-users>
postgis-users Info Page - Open Source Geospatial Foundation<https://lists.osgeo.org/mailman/listinfo/postgis-users>
lists.osgeo.org
A list devoted to the discussion of the use and uses of the PostGIS/PostgreSQL spatial database system. To see the collection of prior postings to the list, visit ...
lists.osgeo.org
Your email address: Your name (optional): You may enter a privacy password below. This provides only mild security, but should prevent others from messing with ...
------------------------------
End of postgis-users Digest, Vol 189, Issue 2
*********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171102/107e780e/attachment-0001.html>
------------------------------
Message: 2
Date: Fri, 3 Nov 2017 09:12:52 +0100
From: Giuseppe Broccolo <g.broccolo.7 at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2
Message-ID:
<CAFtuf8D-hCH-d0J1QC_EH-VRSUwNLdPyRpoZ3hVGPo8LPZe2PA at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Hi Ben,
2017-11-02 20:15 GMT+01:00 Q S <qsun7 at hotmail.com>:
> Hi Giuseppe
>
> Apologies for the typo. The error is this:
>
> ERROR: could not find function "gserialized_gidx_geog_overlaps" in
> /usr/pgsql-9.2/lib/postgis-2.3.so
>
> I have updated at least two hosts without any issues. but this particular
> one gives me trouble.
>
> All the hosts are linux::
>
> Linux ldevpg-db03.fcc.gov 2.6.18-419.el5 #1 SMP Wed Feb 22 22:40:57 EST
> 2017 x86_64 x86_64 x86_64 GNU/Linux
>
> I used source code and did the configure/make/make install.
> I did try to uninstall the postgis2.3.0 and reinstall it again. But the
> problem persists.
> I even did a database server restart but the problem is still there.
>
Ok, so PostGIS has been installed compiling source code, did you use the
tarball from the Download area of the official site?
Anyway, here the /usr/pgsql-9.2/lib/postgis-2.3.so compiled object has not
defined the gserialized_gidx_geog_overlaps function, used in BRIN support
added in PostGIS 2.3.0 the last year. Weird, because that piece of code
should not be used by PostgreSQL 9.2. I'm wondering if
/usr/pgsql-9.2/lib/postgis-2.3.so is containing actually 2.0 definition.
Maybe something went wrong during manual installation. One attempt I'd do
is to recompile 2.0 shared object, so that /usr/pgsql-9.2/lib/postgis-2.0.so
is created again, do a make clean of 2.3 and recompile again, than try to
run ALTER EXTENSION (both shared object versions should be present in
/usr/pgsql-9.2/lib/). If this does not work, please add further details
about PostgreSQL installation, and how to reproduce the same steps, in
order to understand what's gone wrong - you mentioned that in other
installations all's gone fine, maybe there are here different starting
conditions.
Giuseppe.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171103/7c977cef/attachment-0001.html>
------------------------------
Subject: Digest Footer
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
------------------------------
End of postgis-users Digest, Vol 189, Issue 3
*********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171109/223bfbc6/attachment.html>
More information about the postgis-users
mailing list