Upgrade to 13.2 and PostGIS

Question

Hello all,  
We're having an issue upgrading to Postgresql 13.2 from 12.6 with the PostGIS extension being present. I have upgraded each database so it's running the latest version of PostGIS (3.0.2) by running:  
SELECT postgis_extensions_upgrade();  
  
And confirmed by running:  
SELECT PostGIS_Version();  
  
But when I ask the instance to upgrade to 13.2 I get the following error:  
ERROR: could not access file "$libdir/rtpostgis-2.5": No such file or directory  
  
The other upgrade errorlog says to check loadable_libraries.txt but this in obviously inaccessible within RDS.   
Any ideas?   
Thanks!

Accepted Answer

Hi  
  
I had the same issue before, when upgrading from version 12 to 13. I used these 3 commands for each database and fixed the issue of loadable_libraries.txt. Let me know if this works? :)   
  
SELECT postgis_extensions_upgrade();  
SELECT PostGIS_Full_Version();  
ALTER EXTENSION postgis UPDATE;

Answer

Thanks! I ran those commands on every PostGIS enabled database and now the upgrade has succeeded. The output of the commands was always "Postgis is already up-to-date" just to add to the confusion.

Upgrade to 13.2 and PostGIS

相關內容