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

[Michal Zimmermann]

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?

```
pg_restore: from TOC record 219; 1259 722261 VIEW geometry_columns postgres
pg_restore: error could not execute query: ERROR:  column s.consrc does not exist
LINE 28:             "replace"("split_part"("s"."consrc", ''''::"text...
```

[1] https://www.postgresql.org/docs/12/release-12.html


Mgr. Michal Zimmermann

M: +420 603 513 860 | E: michal.zimmermann at gmtech.cz

GMtech s.r.o. | Michelská 29/6 | 140 00 Praha 4

kancelář Brno: Kounicova 271/13 | 602 00 Brno

www.gmtech.cz<http://www.symap.cz>



[A57BCAFA]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200114/e07ad309/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-A57BCAFA.png
Type: image/png
Size: 3029 bytes
Desc: Outlook-A57BCAFA.png
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200114/e07ad309/attachment.png>