[postgis-devel] In Place Upgrade

Paul Ramsey pramsey at cleverelephant.ca
Tue Sep 24 09:23:51 PDT 2019


Anyone done an in-place upgrade from 11/2.5 to 12/3?
I'm working through one w/ the PGDG packages, found a couple bugs already,
which are fixable in the packages, but just hit one that looks fatal on our
side... at the end of pg_upgrade, we hit this one:

pg_restore: from TOC entry 214; 1259 18025 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...
                                            ^
HINT:  Perhaps you meant to reference the column "s.conkey" or the column
"s.conbin".
Command was:
-- For binary upgrade, must preserve pg_type oid
SELECT
pg_catalog.binary_upgrade_set_next_pg_type_oid('18027'::pg_catalog.oid);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20190924/84027ef0/attachment.html>


More information about the postgis-devel mailing list