<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>