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";