[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 3
From: Q S <qsun7 () hotmail ! com>
Date: 2017-11-09 13:40:52
Message-ID: BLUPR0501MB8828D36E5FF2A0724EE1FE9E1570 () BLUPR0501MB882 ! namprd05 ! prod ! outlook ! com
[Download RAW message or body]
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@lists.osgeo.org> on behalf of \
postgis-users-request@lists.osgeo.org \
<postgis-users-request@lists.osgeo.org>
Sent: Friday, November 3, 2017 3:00 PM
To: postgis-users@lists.osgeo.org
Subject: postgis-users Digest, Vol 189, Issue 3
Send postgis-users mailing list submissions to
postgis-users@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@lists.osgeo.org
You can reach the person managing the list at
postgis-users-owner@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@hotmail.com>
To: "postgis-users@lists.osgeo.org" <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2
Message-ID:
<BLUPR0501MB882706DBA0A6132341AC175E15C0@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@lists.osgeo.org> on behalf of \
postgis-users-request@lists.osgeo.org \
<postgis-users-request@lists.osgeo.org>
Sent: Thursday, November 2, 2017 3:00 PM
To: postgis-users@lists.osgeo.org
Subject: postgis-users Digest, Vol 189, Issue 2
Send postgis-users mailing list submissions to
postgis-users@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@lists.osgeo.org
You can reach the person managing the list at
postgis-users-owner@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@gmail.com>
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] upgrade extension error
Message-ID:
<CAFtuf8C=7OBOTYyqgeGkMsnVcm+tpn5bJfSm=sD0F=28q68q2A@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Hi Ben,
2017-10-31 18:48 GMT+01:00 Q S <qsun7@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@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@gmail.com>
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2
Message-ID:
<CAFtuf8D-hCH-d0J1QC_EH-VRSUwNLdPyRpoZ3hVGPo8LPZe2PA@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Hi Ben,
2017-11-02 20:15 GMT+01:00 Q S <qsun7@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@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
------------------------------
End of postgis-users Digest, Vol 189, Issue 3
*********************************************
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} \
--></style> </head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="color: rgb(0, 0, 0); font-family: Calibri, \
Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI \
Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", \
EmojiSymbols;" dir="ltr"> <p style="font-size: 12pt;"><span style="font-family: \
Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe \
UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android \
Emoji", EmojiSymbols; font-size: 13.3333px;">Hi Giuseppe,</span><br> </p>
<p style=""><span style="font-size: 13.3333px;">Problem solved after recompiling \
postgis 2.0 for postgresql 9.2</span></p> <p style=""><span style="font-size: \
13.3333px;">Thanks a lot for your expert advice.</span></p> <p style=""><span \
style="font-size: 13.3333px;">Have a great day</span></p> <p style=""><span \
style="font-size: 13.3333px;">Ben</span></p> <br>
<br>
<div style="font-size: 12pt; color: rgb(0, 0, 0);">
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" \
style="font-size:11pt" color="#000000"><b>From:</b> postgis-users \
<postgis-users-bounces@lists.osgeo.org> on behalf of \
postgis-users-request@lists.osgeo.org \
<postgis-users-request@lists.osgeo.org><br> <b>Sent:</b> Friday, November 3, \
2017 3:00 PM<br> <b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Subject:</b> postgis-users Digest, Vol 189, Issue 3</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Send postgis-users mailing list submissions to<br>
postgis-users@lists.osgeo.org<br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" id="LPlnk843127" \
previewremoved="true"> https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<div id="LPBorder_GT_15102346993300.1783598284614092" style="margin-bottom: 20px; \
overflow: auto; width: 100%; text-indent: 0px;"> <table \
id="LPContainer_15102346993250.04026232421529152" role="presentation" cellspacing="0" \
style="width: 90%; background-color: rgb(255, 255, 255); position: relative; \
overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; \
border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, \
200);"> <tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_15102346993260.378298689727266" colspan="2" style="vertical-align: \
top; position: relative; padding: 0px; display: table-cell;"> <div \
id="LPRemovePreviewContainer_15102346993260.5349585181390288"></div> <div \
id="LPTitle_15102346993260.29138015739706424" style="top: 0px; color: rgb(0, 120, \
215); font-weight: 400; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe \
UI Light", "Segoe WP Light", "Segoe UI", "Segoe \
WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a \
id="LPUrlAnchor_15102346993260.2957500918639533" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
style="text-decoration: none;">postgis-users Info Page - Open Source Geospatial \
Foundation</a></div> <div id="LPMetadata_15102346993280.17858176442306384" \
style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; \
font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, \
Arial, sans-serif; font-size: 14px; line-height: 14px;"> lists.osgeo.org</div>
<div id="LPDescription_15102346993280.034356009437630286" style="display: block; \
color: rgb(102, 102, 102); font-weight: 400; font-family: wf_segoe-ui_normal, \
"Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: \
14px; line-height: 20px; max-height: 100px; overflow: hidden;"> 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 ...</div> </td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
or, via email, send a message with subject or body 'help' to<br>
postgis-users-request@lists.osgeo.org<br>
<br>
You can reach the person managing the list at<br>
postgis-users-owner@lists.osgeo.org<br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of postgis-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: postgis-users Digest, Vol 189, Issue 2 (Q S)<br>
2. Re: postgis-users Digest, Vol 189, Issue 2 (Giuseppe Broccolo)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 2 Nov 2017 19:15:29 +0000<br>
From: Q S <qsun7@hotmail.com><br>
To: "postgis-users@lists.osgeo.org" \
<postgis-users@lists.osgeo.org><br>
Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2<br>
Message-ID:<br>
\
<BLUPR0501MB882706DBA0A6132341AC175E15C0@BLUPR0501MB882.namprd05.prod.outlook.com><br>
<br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Hi Giuseppe<br>
<br>
Apologies for the typo. The error is this:<br>
<br>
ERROR: could not find function "gserialized_gidx_geog_overlaps" in \
/usr/pgsql-9.2/lib/postgis-2.3.so<br> <br>
I have updated at least two hosts without any issues. but this particular one gives \
me trouble.<br> <br>
All the hosts are linux::<br>
<br>
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<br> <br>
I used source code and did the configure/make/make install.<br>
I did try to uninstall the postgis2.3.0 and reinstall it again. But the problem \
persists.<br> I even did a database server restart but the problem is still \
there.<br> <br>
Thanks for you help.<br>
Ben<br>
<br>
<br>
________________________________<br>
From: postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of \
postgis-users-request@lists.osgeo.org \
<postgis-users-request@lists.osgeo.org><br>
Sent: Thursday, November 2, 2017 3:00 PM<br>
To: postgis-users@lists.osgeo.org<br>
Subject: postgis-users Digest, Vol 189, Issue 2<br>
<br>
Send postgis-users mailing list submissions to<br>
postgis-users@lists.osgeo.org<br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" id="LPlnk525731" \
previewremoved="true"> https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<div id="LPBorder_GT_15102346994150.30054584955003105" style="margin-bottom: 20px; \
overflow: auto; width: 100%; text-indent: 0px;"> <table \
id="LPContainer_15102346994140.2686174646331232" role="presentation" cellspacing="0" \
style="width: 90%; background-color: rgb(255, 255, 255); position: relative; \
overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; \
border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, \
200);"> <tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_15102346994140.23922131921792644" colspan="2" style="vertical-align: \
top; position: relative; padding: 0px; display: table-cell;"> <div \
id="LPRemovePreviewContainer_15102346994140.005023481920328976"></div> <div \
id="LPTitle_15102346994140.9312813096058064" style="top: 0px; color: rgb(0, 120, \
215); font-weight: 400; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe \
UI Light", "Segoe WP Light", "Segoe UI", "Segoe \
WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a \
id="LPUrlAnchor_15102346994150.8046691572214537" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
style="text-decoration: none;">postgis-users Info Page - Open Source Geospatial \
Foundation</a></div> <div id="LPMetadata_15102346994150.9637359433517461" \
style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; \
font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, \
Arial, sans-serif; font-size: 14px; line-height: 14px;"> lists.osgeo.org</div>
<div id="LPDescription_15102346994150.7013014903934802" style="display: block; color: \
rgb(102, 102, 102); font-weight: 400; font-family: wf_segoe-ui_normal, "Segoe \
UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; \
line-height: 20px; max-height: 100px; overflow: hidden;"> 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 ...</div> </td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
postgis-users Info Page - Open Source Geospatial Foundation<<a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" id="LPlnk229833" \
previewremoved="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>> \
<div id="LPBorder_GT_15102347289710.6947936262045527" style="margin-bottom: 20px; \
overflow: auto; width: 100%; text-indent: 0px;"> <table \
id="LPContainer_15102347289690.1916764744997428" role="presentation" cellspacing="0" \
style="width: 90%; background-color: rgb(255, 255, 255); position: relative; \
overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; \
border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, \
200);"> <tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_15102347289700.3147912723351176" colspan="2" style="vertical-align: \
top; position: relative; padding: 0px; display: table-cell;"> <div \
id="LPRemovePreviewContainer_15102347289700.46915774519870745"></div> <div \
id="LPTitle_15102347289700.29396902243755707" style="top: 0px; color: rgb(0, 120, \
215); font-weight: 400; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe \
UI Light", "Segoe WP Light", "Segoe UI", "Segoe \
WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a \
id="LPUrlAnchor_15102347289700.34842768729134543" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
style="text-decoration: none;">postgis-users Info Page - Open Source Geospatial \
Foundation</a></div> <div id="LPMetadata_15102347289700.11213969465409512" \
style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; \
font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, \
Arial, sans-serif; font-size: 14px; line-height: 14px;"> lists.osgeo.org</div>
<div id="LPDescription_15102347289710.44340414959861496" style="display: block; \
color: rgb(102, 102, 102); font-weight: 400; font-family: wf_segoe-ui_normal, \
"Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: \
14px; line-height: 20px; max-height: 100px; overflow: hidden;"> 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 ...</div> </td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
lists.osgeo.org<br>
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 ...<br> \
<br> <br>
<br>
or, via email, send a message with subject or body 'help' to<br>
postgis-users-request@lists.osgeo.org<br>
<br>
You can reach the person managing the list at<br>
postgis-users-owner@lists.osgeo.org<br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of postgis-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: upgrade extension error (Giuseppe Broccolo)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 2 Nov 2017 00:08:10 +0100<br>
From: Giuseppe Broccolo <g.broccolo.7@gmail.com><br>
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>
Subject: Re: [postgis-users] upgrade extension error<br>
Message-ID:<br>
\
<CAFtuf8C=7OBOTYyqgeGkMsnVcm+tpn5bJfSm=sD0F=28q68q2A@mail.gmail.com><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Ben,<br>
<br>
2017-10-31 18:48 GMT+01:00 Q S <qsun7@hotmail.com>:<br>
<br>
> postgresql version: 9.2<br>
><br>
> postgis version: 2.0.<br>
><br>
><br>
> 1. install postgis2.3<br>
> 2. login to postgresql database<br>
> 3. alter postgis update to '2.3.0';<br>
><br>
> ERROR: could not find function "gserialized_gidx_geog_overlaps" in<br>
> /usr/pgsql-9.2/lib/postgis-2.3/so"<br>
><br>
<br>
Could you bring further details about how PostGIS 2.3.0 has been installed?<br>
Through package? On which system (Linux, Windows,...)?<br>
<br>
The oddity is the name of the shared object, that should be<br>
"/usr/pgsql-9.2/lib/postgis-2.3.so" (and not \
"/usr/pgsql-9.2/lib/postgis-2.<br> 3/so").<br>
<br>
All the best,<br>
Giuseppe.<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20171102/aa0318b3/attachment-0001.html" \
id="LPlnk149353" previewremoved="true">http://lists.osgeo.org/pipermail/postgis-users/attachments/20171102/aa0318b3/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@lists.osgeo.org<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" id="LPlnk286778" \
previewremoved="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a> <div \
id="LPBorder_GT_15102347289060.6700757802865327" style="margin-bottom: 20px; \
overflow: auto; width: 100%; text-indent: 0px;"> <table \
id="LPContainer_15102347289030.6190434071642892" role="presentation" cellspacing="0" \
style="width: 90%; background-color: rgb(255, 255, 255); position: relative; \
overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; \
border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, \
200);"> <tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_15102347289040.5005708418874919" colspan="2" style="vertical-align: \
top; position: relative; padding: 0px; display: table-cell;"> <div \
id="LPRemovePreviewContainer_15102347289040.5037714349581375"></div> <div \
id="LPTitle_15102347289040.4617248204962763" style="top: 0px; color: rgb(0, 120, \
215); font-weight: 400; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe \
UI Light", "Segoe WP Light", "Segoe UI", "Segoe \
WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a \
id="LPUrlAnchor_15102347289050.20331200775521752" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
style="text-decoration: none;">postgis-users Info Page - Open Source Geospatial \
Foundation</a></div> <div id="LPMetadata_15102347289050.3921358314655534" \
style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; \
font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, \
Arial, sans-serif; font-size: 14px; line-height: 14px;"> lists.osgeo.org</div>
<div id="LPDescription_15102347289060.5422417657100149" style="display: block; color: \
rgb(102, 102, 102); font-weight: 400; font-family: wf_segoe-ui_normal, "Segoe \
UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; \
line-height: 20px; max-height: 100px; overflow: hidden;"> 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 ...</div> </td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
postgis-users Info Page - Open Source Geospatial Foundation<<a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" id="LPlnk623125" \
previewremoved="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>> \
<div id="LPBorder_GT_15102347633160.4389096731025859" style="margin-bottom: 20px; \
overflow: auto; width: 100%; text-indent: 0px;"> <table \
id="LPContainer_15102347633140.7159370451029765" role="presentation" cellspacing="0" \
style="width: 90%; background-color: rgb(255, 255, 255); position: relative; \
overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; \
border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, \
200);"> <tbody>
<tr valign="top" style="border-spacing: 0px;">
<td id="TextCell_15102347633140.8091239696632715" colspan="2" style="vertical-align: \
top; position: relative; padding: 0px; display: table-cell;"> <div \
id="LPRemovePreviewContainer_15102347633150.60551184189652"></div> <div \
id="LPTitle_15102347633150.8474886494820555" style="top: 0px; color: rgb(0, 120, \
215); font-weight: 400; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe \
UI Light", "Segoe WP Light", "Segoe UI", "Segoe \
WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a \
id="LPUrlAnchor_15102347633150.16400655209397663" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" \
style="text-decoration: none;">postgis-users Info Page - Open Source Geospatial \
Foundation</a></div> <div id="LPMetadata_15102347633150.5529647608798818" \
style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; \
font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, \
Arial, sans-serif; font-size: 14px; line-height: 14px;"> lists.osgeo.org</div>
<div id="LPDescription_15102347633160.9214178981754877" style="display: block; color: \
rgb(102, 102, 102); font-weight: 400; font-family: wf_segoe-ui_normal, "Segoe \
UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; \
line-height: 20px; max-height: 100px; overflow: hidden;"> 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 ...</div> </td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
lists.osgeo.org<br>
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 ...<br> \
<br> <br>
<br>
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 189, Issue 2<br>
*********************************************<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20171102/107e780e/attachment-0001.html" \
id="LPlnk97410" previewremoved="true">http://lists.osgeo.org/pipermail/postgis-users/attachments/20171102/107e780e/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 3 Nov 2017 09:12:52 +0100<br>
From: Giuseppe Broccolo <g.broccolo.7@gmail.com><br>
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>
Subject: Re: [postgis-users] postgis-users Digest, Vol 189, Issue 2<br>
Message-ID:<br>
\
<CAFtuf8D-hCH-d0J1QC_EH-VRSUwNLdPyRpoZ3hVGPo8LPZe2PA@mail.gmail.com><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Ben,<br>
<br>
2017-11-02 20:15 GMT+01:00 Q S <qsun7@hotmail.com>:<br>
<br>
> Hi Giuseppe<br>
><br>
> Apologies for the typo. The error is this:<br>
><br>
> ERROR: could not find function "gserialized_gidx_geog_overlaps" in<br>
> /usr/pgsql-9.2/lib/postgis-2.3.so<br>
><br>
> I have updated at least two hosts without any issues. but this particular<br>
> one gives me trouble.<br>
><br>
> All the hosts are linux::<br>
><br>
> Linux ldevpg-db03.fcc.gov 2.6.18-419.el5 #1 SMP Wed Feb 22 22:40:57 EST<br>
> 2017 x86_64 x86_64 x86_64 GNU/Linux<br>
><br>
> I used source code and did the configure/make/make install.<br>
> I did try to uninstall the postgis2.3.0 and reinstall it again. But the<br>
> problem persists.<br>
> I even did a database server restart but the problem is still there.<br>
><br>
<br>
Ok, so PostGIS has been installed compiling source code, did you use the<br>
tarball from the Download area of the official site?<br>
<br>
Anyway, here the /usr/pgsql-9.2/lib/postgis-2.3.so compiled object has not<br>
defined the gserialized_gidx_geog_overlaps function, used in BRIN support<br>
added in PostGIS 2.3.0 the last year. Weird, because that piece of code<br>
should not be used by PostgreSQL 9.2. I'm wondering if<br>
/usr/pgsql-9.2/lib/postgis-2.3.so is containing actually 2.0 definition.<br>
Maybe something went wrong during manual installation. One attempt I'd do<br>
is to recompile 2.0 shared object, so that /usr/pgsql-9.2/lib/postgis-2.0.so<br>
is created again, do a make clean of 2.3 and recompile again, than try to<br>
run ALTER EXTENSION (both shared object versions should be present in<br>
/usr/pgsql-9.2/lib/). If this does not work, please add further details<br>
about PostgreSQL installation, and how to reproduce the same steps, in<br>
order to understand what's gone wrong - you mentioned that in other<br>
installations all's gone fine, maybe there are here different starting<br>
conditions.<br>
<br>
Giuseppe.<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20171103/7c977cef/attachment-0001.html" \
id="LPlnk103152" previewremoved="true">http://lists.osgeo.org/pipermail/postgis-users/attachments/20171103/7c977cef/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@lists.osgeo.org<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" id="LPlnk626965" \
previewremoved="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> \
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 189, Issue 3<br>
*********************************************<br>
</div>
</span></font></div>
</div>
</div>
</body>
</html>
[Attachment #4 (unknown)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic