[postgis-users] pg_dump on upgraded server

[Paolo Cavallini]

Hi

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
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/