<div dir="ltr">Thanks for all the suggestions. I decided to take the safe route by running pg_dumpall then turning on Postgresql 13 with Postgis 3.1. Once the data was loaded the system was working perfectly. <div><br></div><div>I didn't mention this in my original email but one of my databases has nealy 100M records. I didn't want to have to recreate it if I screwed up the pg_upgrade path. pg_dumpall and reloading took a while but the end result is a nice new postgresql server with the latest PostGIS. </div><div><br></div><div>Thanks again,</div><div>Clifford</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Dec 17, 2020 at 11:45 PM Tomas Straupis <<a href="mailto:tomasstraupis@gmail.com">tomasstraupis@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">2020-12-17, kt, 22:46 Clifford Snow rašė:<br>
> I want to upgrade Postgresql from 11 to 13 and PostGIS from 2.5 to 3.1 on a Fedora Workstation. Is it possible?<br>
<br>
If I understand you correctly, you're using both postgresql and<br>
postgis packages from fedora repos?<br>
If so, these are my notes, I use Fedora:<br>
I've found it impossible to upgrade using only core packages,<br>
because if both postgre and postgis versions change, upgraded system<br>
is unusable (db upgrade fails), because you have to upgrade postgresql<br>
and during upgrade it needs access to both new and OLD versions of<br>
postgis libraries, and old libraries have to be compiled using all old<br>
libraries used in old postgresql. Therefore several years ago I<br>
switched to using core postgresql but postgis compiled from source.<br>
Now my notes on upgrading are:<br>
1. BEFORE upgrading postgresql upgrade postgis to whatever newest<br>
version of postgis you want to use.<br>
2. Make a copy of postgis/SFCGAL etc. libraries (.so files), for<br>
example everything from /usr/lib64/pgsql<br>
3. vacuumdb -a -f -v<br>
4. pg_dump (just to be on the safe side, but not mandatory)<br>
5. Upgrade Fedora (and postgresql with it).<br>
6. Copy the files you copied in step 2 to<br>
/usr/lib64/pgsql/postgres-XX/lib where XX - old version of postgresql<br>
you were upgrading from.<br>
7. Compile postgis for the new upgraded postgresql<br>
8. Upgrade the database<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>@osm_washington<br></div><div><a href="https://www.snowandsnow.us" target="_blank">www.snowandsnow.us</a></div><div>OpenStreetMap: Maps with a human touch</div></div></div></div></div></div></div>