[postgis-users] pg_dump on upgraded server

Paolo Cavallini cavallini at faunalia.it
Wed Apr 3 09:40:43 PDT 2019


On 03/04/19 18:32, Sandro Santilli wrote:

> Very interesting case, as it shows a problem with the idea
> that dropping minor version from the SO would fix this kind
> of problem.
> So, I guess what happens is that pg_dump wants to use the
> "canonical output" functions for the geometry types of some
> database (or why would pg_dump require that library?).
> Can you confirm the above ? Are you POSITIVE the database
> you're dumping does NOT use PostGIS types at all ?
> There must be, in that database, some record in pg_proc
> where probin like '%postgis%', can you check that ?
> In theory, any such function would be replaced by running
> a soft upgrade of PostGIS in that database.

unfortunately alter extension does not upgrade, and the error in
upgradecluster is still the same.
starting to feel lost.
thanks for any help.
Paolo Cavallini - www.faunalia.eu

More information about the postgis-users mailing list