uninstall_rtpostgis.sql to remove.
From: Andrew Hardy
Sent: Thursday, September 5, 2024 12:26 PM
To: Andrew Hardy ; postgis-users@lists.osgeo.org;
s...@kbt.io
Subject: Re: Update postgis in a replicated PostgreSQL 12 database now with
postgis-3
Sandro,
Thanks.
To be completely clear
Sandro,
Thanks.
To be completely clear then
Run SELECT postgis_extensions_upgrade(); twice anyway
Even if one ultimately hopes to end up running
https://postgis.net/stuff/uninstall_rtpostgis.sql
right?
On Thu, 5 Sept 2024 at 15:15, Sandro Santilli wrote:
> On Thu, Sep 05, 2024 at 09:24:1
On Thu, Sep 05, 2024 at 09:24:10AM +0100, Andrew Hardy wrote:
> SELECT postgis_extensions_upgrade();
>
> -- I have not yet run this (neither once nor twice) - I was in the process
> in my earlier post of discussing if it would still work given my first
> mistake
Please run it, then report back.
Hi Sandro,
Thank you so much for your kind input to this issue, I really
appreciate it. I have one final question:
-- Subsequently I have now decided we do not actually need the raster
functionality, so I am thinking I could remove it before trying to load v12
database into v16.
-- However I wa
On Mon, Jul 01, 2024 at 04:37:37PM +0100, Andrew Hardy wrote:
> Thank you so much for your response, I appreciate it.
>
> I omitted to mention that before I messaged I had tried to resolve this in
> the pg_proc table and ran the following query:
>
> UPDATE pg_proc SET probin = '$libdir/postgis-3
Thank you so much for your response, I appreciate it.
I omitted to mention that before I messaged I had tried to resolve this in
the pg_proc table and ran the following query:
UPDATE pg_proc SET probin = '$libdir/postgis-3' WHERE probin =
'$libdir/rtpostgis-2.5';
This was probably a mistake (no
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 l
