binary upgade errors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux