[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