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

[rmrodriguez at carto.com]

Hi,

On Tue, Jan 14, 2020 at 10:08 AM Michal Zimmermann <
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200114/81359e58/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-A57BCAFA.png
Type: image/png
Size: 3029 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200114/81359e58/attachment.png>