[postgis-users] pg_dump on upgraded server

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

Hi again

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

> 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 ?

the database is using it, but I'm dumping only a schema without PostGIS
functions, I hoped this was enough.

> There must be, in that database, some record in pg_proc
> where probin like '%postgis%', can you check that ?

yes, I confirm

> In theory, any such function would be replaced by running
> a soft upgrade of PostGIS in that database.

how do I do a soft upgrade, given that alter extension says the function
is already installed in the database?

Thanks a lot.
Paolo Cavallini - www.faunalia.eu

More information about the postgis-users mailing list