<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="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p><span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">Hi </span><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;">Giuseppe</span></p>
<p><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;">Apologies for the typo. The error is this:</span></p>
<p><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;"><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;">ERROR:
could not find function "gserialized_gidx_geog_overlaps" in </span><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;">/usr/pgsql-9.2/lib/postgis-2.3.</span></span><span style="font-size: 13.3333px;">so</span></p>
<p><span style="font-size: 13.3333px;">I have updated at least two hosts without any issues. but this particular one gives me trouble.</span></p>
<p><span style="font-size: 13.3333px;">All the hosts are linux::</span></p>
<p><span style="font-size: 13.3333px;"></p>
<div>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</div>
<div><br>
</div>
<div>I used source code and did the configure/make/make install.</div>
<div>I did try to uninstall the postgis2.3.0 and reinstall it again. But the problem persists.</div>
<div>I even did a database server restart but the problem is still there.</div>
<div><br>
</div>
<div>Thanks for you help.</div>
<div>Ben</div>
<br>
</span>
<p></p>
<br>
<div style="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> Thursday, November 2, 2017 3:00 PM<br>
<b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Subject:</b> postgis-users Digest, Vol 189, Issue 2</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="LPlnk181388" previewremoved="true">
https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<div id="LPBorder_GT_15096498066290.7557284208019692" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;">
<table id="LPContainer_15096498066210.97390165245525" 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_15096498066240.6059444094381983" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;">
<div id="LPRemovePreviewContainer_15096498066240.32094392899652635"></div>
<div id="LPTitle_15096498066240.33069826586394546" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; 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_15096498066250.8131410130502779" 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_15096498066260.19870564770863708" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; 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_15096498066270.34519207871046276" style="display: block; color: rgb(102, 102, 102); font-weight: normal; 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;">
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 ...</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: 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="LPlnk2281" 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="LPlnk970010" previewremoved="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
<div id="LPBorder_GT_15096498314150.7682776658140427" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;">
<table id="LPContainer_15096498314110.15003975363215383" 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_15096498314120.11864552657702498" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;">
<div id="LPRemovePreviewContainer_15096498314120.5440972385823641"></div>
<div id="LPTitle_15096498314130.025397103713582947" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; 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_15096498314130.9175089177867719" 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_15096498314130.5705092751861469" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; 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_15096498314140.48553015606120264" style="display: block; color: rgb(102, 102, 102); font-weight: normal; 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;">
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 ...</div>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 189, Issue 2<br>
*********************************************<br>
</div>
</span></font></div>
</div>
</div>
</body>
</html>