<div dir="ltr">Hi Team,<div><br></div><div>We are running on PostgreSQL v10.12 and we are in the process to upgrade it to v13. We are using PostGIS v2.5.4 on v10.12.</div><div><br></div><div>We want to upgrade PostGIS as well to 3.1.2. We plan to follow below approach</div><div><br></div><div>1. Upgrade PostGIS from 2.5.4 to 3.1.2 on PostgreSQL 10.12</div><div>2. Upgrade PostgreSQL 10.12 to 13</div><div><br></div><div>When performing step 1, we are getting below error</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">geo=# alter extension postgis update to '3.1.2';</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">WARNING:<span class="gmail-Apple-converted-space">  </span>unpackaging raster</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">WARNING:<span class="gmail-Apple-converted-space">  </span>PostGIS Raster functionality has been unpackaged</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">HINT:<span class="gmail-Apple-converted-space">  </span>type `SELECT postgis_extensions_upgrade();` to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">ERROR:<span class="gmail-Apple-converted-space">  </span>could not access file "$libdir/postgis-2.5": No such file or directory</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">CONTEXT:<span class="gmail-Apple-converted-space">  </span>PL/pgSQL function _postgis_drop_function_if_needed(text,text) line 6 at FOR over SELECT rows</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">geo=# SELECT postgis_extensions_upgrade();</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">WARNING:<span class="gmail-Apple-converted-space">  </span>unpackaging raster</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">WARNING:<span class="gmail-Apple-converted-space">  </span>PostGIS Raster functionality has been unpackaged</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">HINT:<span class="gmail-Apple-converted-space">  </span>type `SELECT postgis_extensions_upgrade();` to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">ERROR:<span class="gmail-Apple-converted-space">  </span>could not access file "$libdir/postgis-2.5": No such file or directory</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">CONTEXT:<span class="gmail-Apple-converted-space">  </span>PL/pgSQL function _postgis_drop_function_if_needed(text,text) line 6 at FOR over SELECT rows</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">SQL statement "ALTER EXTENSION postgis UPDATE TO "3.1.2";"</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">PL/pgSQL function postgis_extensions_upgrade() line 22 at EXECUTE</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">







<br class="gmail-Apple-interchange-newline"></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;line-height:normal;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="arial, sans-serif">We removed the old 2.5.4 packages and installed 3.1.2</font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">ls -l /usr/pgsql-10/lib | grep postgis</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-rwxr-xr-x 1 root root 1047128 Jun 29<span class="gmail-Apple-converted-space">  </span>2021 </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)"><b>postgis</b></span><span style="font-variant-ligatures:no-common-ligatures">-3.so</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-rwxr-xr-x 1 root root<span class="gmail-Apple-converted-space">  </span>850416 Jun 29<span class="gmail-Apple-converted-space">  </span>2021 </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)"><b>postgis</b></span><span style="font-variant-ligatures:no-common-ligatures">_raster-3.so</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-rwxr-xr-x 1 root root<span class="gmail-Apple-converted-space">  </span>435656 Jun 29<span class="gmail-Apple-converted-space">  </span>2021 </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)"><b>postgis</b></span><span style="font-variant-ligatures:no-common-ligatures">_sfcgal-3.so</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-rwxr-xr-x 1 root root<span class="gmail-Apple-converted-space">  </span>565008 Jun 29<span class="gmail-Apple-converted-space">  </span>2021 </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)"><b>postgis</b></span><span style="font-variant-ligatures:no-common-ligatures">_topology-3.so</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">




<br class="gmail-Apple-interchange-newline"></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p></div></div>