<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Thanks, Regina! I am running PostgeSQL 12 now!<br>
</p>
<p>However, when I ran <b><span
style="font-size:12.5pt;font-family:"inherit",serif;color:#993333;border:none
windowtext 1.0pt;padding:0in">SELECT</span></b><span
style="font-size:12.5pt;font-family:"Courier
New";color:#222222"> PostGIS_Extensions_Upgrade</span><span
style="font-size:12.5pt;font-family:"Courier
New";color:#66CC66;border:none windowtext
1.0pt;padding:0in">()</span><span
style="font-size:12.5pt;font-family:"Courier
New";color:#222222">; the second time, I have the following
msg. <br>
</span></p>
<p><br>
<font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">NOTICE:
Extension postgis_sfcgal is not available or not packagable
for some reason <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">NOTICE:
Packaging extension postgis_raster</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">
WARNING: 'postgis.gdal_datapath' is already set and cannot be
changed until you reconnect <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">WARNING:
'postgis.gdal_enabled_drivers' is already set and cannot be
changed until you reconnect <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">WARNING:
'postgis.enable_outdb_rasters' is already set and cannot be
changed until you reconnect <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);"><br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">
ERROR: function public.st_srid(geometry) does not exist <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">LINE 1:
..._makeemptyraster($1, $2, $3, $4, $5, -($5), 0, 0,
public.ST_... ^ <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">HINT: No
function matches the given name and argument types. You might
need to add explicit type casts. <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">QUERY:
SELECT public.ST_makeemptyraster($1, $2, $3, $4, $5, -($5), 0,
0, public.ST_SRID('POINT(0 0)'::geometry)) <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">CONTEXT:
SQL statement "CREATE EXTENSION postgis_raster FROM
unpackaged" <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">PL/pgSQL
function postgis_extensions_upgrade() line 48 at EXECUTE <br>
</span></font></p>
<p><font size="-2" face="Courier New, Courier, monospace"><span
style="font-size: 12.5pt; color: rgb(34, 34, 34);">SQL state:
42883</span></font></p>
<p><span style="font-size:12.5pt;font-family:"Courier
New";color:#222222"><br>
</span></p>
<div class="moz-cite-prefix">On 12/22/19 8:09 PM, Regina Obe wrote:<br>
</div>
<blockquote type="cite"
cite="mid:000701d5b93e$62df4d10$289de730$@pcorp.us">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:inherit;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">NO
NO don’t do that. Those set of libraries aren’t compatible
with each other.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The
PostGIS 3.0 and 2.5 from 12 are compatible with each other
however.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">So
<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">What
you want to do is<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">cp
/usr/lib/postgresql/12/lib/postgis-3.so
/usr/lib/postgresql/12/lib/postgis-2.5.so<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">cp
/usr/lib/postgresql/12/lib/postgis_raster-3.so
/usr/lib/postgresql/12/lib/rtpostgis-2.5.so<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">cp
/usr/lib/postgresql/12/lib/postgis_topology-3.so
/usr/lib/postgresql/12/lib/postgis_topology-2.5.so<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Then
after the upgrade in each of your databases run:<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"
style="background:#F2F2F2;vertical-align:baseline"><b><span
style="font-size:12.5pt;font-family:"inherit",serif;color:#993333;border:none
windowtext 1.0pt;padding:0in">SELECT</span></b><span
style="font-size:12.5pt;font-family:"Courier
New";color:#222222"> PostGIS_Extensions_Upgrade</span><span
style="font-size:12.5pt;font-family:"Courier
New";color:#66CC66;border:none windowtext
1.0pt;padding:0in">()</span><span
style="font-size:12.5pt;font-family:"Courier
New";color:#222222">;<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">And
then run it again to rebundle the raster into it’s own
extension<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"
style="background:#F2F2F2;vertical-align:baseline"><b><span
style="font-size:12.5pt;font-family:"inherit",serif;color:#993333;border:none
windowtext 1.0pt;padding:0in">SELECT</span></b><span
style="font-size:12.5pt;font-family:"Courier
New";color:#222222"> PostGIS_Extensions_Upgrade</span><span
style="font-size:12.5pt;font-family:"Courier
New";color:#66CC66;border:none windowtext
1.0pt;padding:0in">()</span><span
style="font-size:12.5pt;font-family:"Courier
New";color:#222222">;<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Then
if you don’t need raster, you can <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">DROP
EXTENSION postgis_raster;<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Once
you are done upgrading your databases, you can delete thr
*-2.5.so files you created in the 12 cluster.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
postgis-users
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On
Behalf Of </b>Bo Guo<br>
<b>Sent:</b> Sunday, December 22, 2019 10:01 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [postgis-users] PostgreSQL 12 and
PostGIS<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Thanks, Regina,<o:p></o:p></p>
<p>I copied the three 2.5 lib files from<span
style="font-family:"Courier New""> </span><span
style="font-size:10.0pt;font-family:"Courier New"">/usr/lib/postgresql/11/lib</span>
to <span style="font-size:10.0pt;font-family:"Courier
New"">/usr/lib/postgresql/12/lib</span>:<o:p></o:p></p>
<p style="margin-bottom:12.0pt"><span
style="font-size:10.0pt;font-family:"Courier New"">guob@yuma:/usr/lib/postgresql/12/lib$
ls -al *post*<br>
-rw-r--r-- 1 root root 456832 Dec 22 19:49 postgis-2.5.so<br>
-rw-r--r-- 1 root root 1351536 Oct 28 21:24 postgis-3.so<br>
-rw-r--r-- 1 root root 847424 Oct 28 21:24
postgis_raster-3.so<br>
-rw-r--r-- 1 root root 364224 Dec 22 19:49
postgis_topology-2.5.so<br>
-rw-r--r-- 1 root root 569152 Oct 28 21:24
postgis_topology-3.so<br>
-rw-r--r-- 1 root root 100264 Nov 12 03:33 postgres_fdw.so<br>
-rw-r--r-- 1 root root 399136 Dec 22 19:50 rtpostgis-2.5.so</span><o:p></o:p></p>
<p>However, the three lib files are still in the <span
style="font-size:10.0pt;font-family:"Courier New"">loadable_libraries.txt</span>
file.<o:p></o:p></p>
<p>Bo<o:p></o:p></p>
<div>
<p class="MsoNormal">On 12/22/19 7:42 PM, Regina Obe wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>Bo,<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Do you have the postgis-2.5.so, rtpostgis-2.5.so, postgis_topology-2.5.so<o:p></o:p></pre>
<pre>files in<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>/usr/lib/postgresql/11/lib<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>And<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>/usr/lib/postgresql/12/lib<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Those are the files it's complaining about. <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>From: postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org" moz-do-not-send="true">mailto:postgis-users-bounces@lists.osgeo.org</a>] On Behalf<o:p></o:p></pre>
<pre>Of Bo Guo<o:p></o:p></pre>
<pre>Sent: Sunday, December 22, 2019 9:16 PM<o:p></o:p></pre>
<pre>To: <a href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre>
<pre>Subject: Re: [postgis-users] PostgreSQL 12 and PostGIS<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Regina and Stefan,<o:p></o:p></pre>
<pre>I might have run into a similar issues today as I was trying to upgrade<o:p></o:p></pre>
<pre>PostgreSQL 11 w/ PostGIS 2.5 to PostgreSQL 12 w/ PostGIS 3.0.<o:p></o:p></pre>
<pre>The pg_upgradecluster command (sudo pg_upgradecluster -m upgrade 11 main)<o:p></o:p></pre>
<pre>failed its check for the following required libraries:<o:p></o:p></pre>
<pre> could not load library "$libdir/postgis-2.5": ERROR: could not access<o:p></o:p></pre>
<pre>file "$libdir/postgis-2.5": No such file or directory<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre> could not load library "$libdir/rtpostgis-2.5": ERROR: could not access<o:p></o:p></pre>
<pre>file "$libdir/rtpostgis-2.5": No such file or directory<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre> could not load library "$libdir/postgis_topology-2.5": ERROR: could not<o:p></o:p></pre>
<pre>access file "$libdir/postgis_topology-2.5": No such file or directory<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>I have postgis-2.5 in the /usr/share/postgresql/11/contrib/ folder AND<o:p></o:p></pre>
<pre>/usr/share/postgresql/12/contrib/ folder. I also have postgis-3.0 under<o:p></o:p></pre>
<pre>/usr/share/postgresql/12/contrib/. <o:p></o:p></pre>
<pre>Thanks for your help!<o:p></o:p></pre>
<pre>Bo<o:p></o:p></pre>
<pre>Gistic Research, Inc.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>On 10/4/19 8:16 AM, Regina Obe wrote:<o:p></o:p></pre>
<pre>Stefan,<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Which distro do you get your PostgreSQL 12 from. Im assuming<o:p></o:p></pre>
<pre>apt.postgresql.org<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>If so you should report on their mailing list, as that would be a packaging<o:p></o:p></pre>
<pre>bug,not a PostGIS one and no one on the PostGIS project is on the apt team.<o:p></o:p></pre>
<pre><a href="https://www.postgresql.org/list/pgsql-pkg-debian/" moz-do-not-send="true">https://www.postgresql.org/list/pgsql-pkg-debian/</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Thanks,<o:p></o:p></pre>
<pre>Regina<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>From: postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org" moz-do-not-send="true">mailto:postgis-users-bounces@lists.osgeo.org</a>] On Behalf<o:p></o:p></pre>
<pre>Of Stefan Wolf<o:p></o:p></pre>
<pre>Sent: Friday, October 4, 2019 6:19 AM<o:p></o:p></pre>
<pre>To: <a href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre>
<pre>Subject: [postgis-users] PostgreSQL 12 and PostGIS<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Today Ive installed the brand new PostgreSQL 12 on Ubuntu 18.04<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>apt-get install postgis will install PostGIS 2.5.2, but the PATH is<o:p></o:p></pre>
<pre>wrong: /usr/share/postgresql/11/
<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>So CREATE EXTENSION postgis will fail.<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Greetings from Berlin<o:p></o:p></pre>
<pre>-Stefan Wolf-<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>postgis-users mailing list<o:p></o:p></pre>
<pre><a href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre>
<pre><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>postgis-users mailing list<o:p></o:p></pre>
<pre><a href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a><o:p></o:p></pre>
<pre><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre>
</blockquote>
<pre>-- <o:p></o:p></pre>
<pre>Regards,<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Bo Guo, PhD, PE<o:p></o:p></pre>
<pre>President<o:p></o:p></pre>
<pre>Gistic Research, Inc.<o:p></o:p></pre>
<pre>2033 E Warner Rd Ste 105<o:p></o:p></pre>
<pre>Tempe, AZ 85284<o:p></o:p></pre>
<pre><a href="http://www.gisticinc.com" moz-do-not-send="true">www.gisticinc.com</a><o:p></o:p></pre>
<pre><a href="http://www.youtube.com/linearbench" moz-do-not-send="true">www.youtube.com/linearbench</a><o:p></o:p></pre>
<pre>Office: 480-656-9962<o:p></o:p></pre>
<pre>Cell: 602-570-4697<o:p></o:p></pre>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Regards,
Bo Guo, PhD, PE
President
Gistic Research, Inc.
2033 E Warner Rd Ste 105
Tempe, AZ 85284
<a class="moz-txt-link-abbreviated" href="http://www.gisticinc.com">www.gisticinc.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.youtube.com/linearbench">www.youtube.com/linearbench</a>
Office: 480-656-9962
Cell: 602-570-4697</pre>
</body>
</html>