|
hi all. first time posting here. I have been unsuccessfully trying to use pg_upgrade to upgrade from 9.6 to 10.4. we have the uint extension in some of the databases. a combination of that extension and probably how we have used it is causing the upgrade to fail. I will include the error msg.
can anyone with some experience please point me in the right direction to fix it ? thanks, david output from pg_upgrade: command: "/usr/pgsql-10.4/bin/pg_restore" --host /var/lib/pgsql/10.4 --port 50432 --username postgres --exit-on-error --verbose --dbname 'dbname=devel8' "pg_upgrade_dump_271840.custom" >> "pg_upgrade_dump_271840.log"
2>&1 pg_restore: connecting to database for restore pg_restore: creating pg_largeobject "pg_largeobject" pg_restore: creating pg_largeobject_metadata "pg_largeobject_metadata" pg_restore: creating SCHEMA "its" pg_restore: creating SCHEMA "public" pg_restore: creating COMMENT "SCHEMA "public"" pg_restore: creating EXTENSION "uint" pg_restore: creating COMMENT "EXTENSION "uint"" pg_restore: creating DOMAIN "its.adj_id_t" pg_restore: creating DOMAIN "its.any_id_t" pg_restore: creating DOMAIN "its.bigint_id_t" pg_restore: creating SHELL TYPE "public.uint1" pg_restore: creating FUNCTION "public.uint1in("cstring")" pg_restore: creating FUNCTION "public.uint1out("public"."uint1")" pg_restore: creating TYPE "public.uint1" pg_restore: creating FUNCTION "public.uint1(integer)" pg_restore: creating DOMAIN "its.bool_t" pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 4538; 1247 280489 DOMAIN bool_t postgres pg_restore: [archiver (db)] could not execute query: ERROR: cannot cast type integer to public.uint1 Command was: -- For binary upgrade, must preserve pg_type oid SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('280489'::pg_catalog.oid); CREATE DOMAIN "its"."bool_t" AS "public"."uint1" DEFAULT (0)::"public"."uint1"; |
