[postgis-users] pg_upgrade from postgresql 11 postgis 3 to postgresql 12 postgis 3

Michal Zimmermann michal.zimmermann at gmtech.cz
Tue Jan 14 01:25:07 PST 2020


OMG, forgot to `ALTER EXTENSION postgis update` one of the databases 😕 Thank you!
________________________________
From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of rmrodriguez at carto.com <rmrodriguez at carto.com>
Sent: Tuesday, January 14, 2020 10:22
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] pg_upgrade from postgresql 11 postgis 3 to postgresql 12 postgis 3

Hi,

On Tue, Jan 14, 2020 at 10:08 AM Michal Zimmermann <michal.zimmermann at gmtech.cz<mailto:michal.zimmermann at gmtech.cz>> wrote:
Hi,
I'm having an issue upgrading from postgresql 11 postgis 3 to postgresql 12 postgis 3 via pg_upgrade utility. That's because pg_constraint.consrc was removed in postgresql 12 [1]. Is it possible to do such upgrade or do I need to run pg_dumpall and upgrade semi-manually?


Can you confirm the dump comes from 3.0? Both 2.5.2 and 3.0 changed `pg_constraint.consrc` with `pg_get_constraintdef` so it shouldn't be complaining. You can check the version in the SQL scripts with `Select postgis_full_version()`.


Regards,
--
Raúl Marín Rodríguez
carto.com<http://carto.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200114/8a622eb8/attachment.html>


More information about the postgis-users mailing list