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 <[email protected]> on behalf of [email protected] <[email protected]> Sent: Friday, November 3, 2017 3:00 PM To: [email protected] Subject: postgis-users Digest, Vol 189, Issue 3 Send postgis-users mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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 <[email protected]> To: "[email protected]" <[email protected]> Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2 Message-ID: <blupr0501mb882706dba0a6132341ac175e1...@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 <[email protected]> on behalf of [email protected] <[email protected]> Sent: Thursday, November 2, 2017 3:00 PM To: [email protected] Subject: postgis-users Digest, Vol 189, Issue 2 Send postgis-users mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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 <[email protected]> To: PostGIS Users Discussion <[email protected]> Subject: Re: [postgis-users] upgrade extension error Message-ID: <CAFtuf8C=7OBOTYyqgeGkMsnVcm+tpn5bJfSm=sD0F=28q68...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi Ben, 2017-10-31 18:48 GMT+01:00 Q S <[email protected]>: > 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 [email protected] 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 <[email protected]> To: PostGIS Users Discussion <[email protected]> Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2 Message-ID: <caftuf8d-hch-d0j1qc_eh-vrsuwnldpyrpoz3hvgpo8lpze...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi Ben, 2017-11-02 20:15 GMT+01:00 Q S <[email protected]>: > 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 [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users ------------------------------ End of postgis-users Digest, Vol 189, Issue 3 *********************************************
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
