Update postgis in a replicated PostgreSQL 12 database now with postgis-3

[Sandro Santilli]

Hi Andrew, replies inline

On Mon, Jun 24, 2024 at 05:38:50PM +0100, Andrew Hardy wrote:

> We noticed some odd failures executing a SELECT on a table with a point
> type column.  The error was: 'could not access file "$libdir/postgis-2.5":
> No such file or directory' .

This means you have some left-over old PostGIS functions in your
database, so the upgrade was not complete. What does the following
query return ? 

  SELECT postgis_full_version()

--strk;
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 659 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240625/bdb243eb/attachment.sig>