binary upgade errors

From: David Modica <davidmo(at)imaginesoftware(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: binary upgade errors
Date: 2018-06-14 15:51:20
Message-ID: 7cb957dd12774a52ac8a680b73910c5b@imaginesoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2018-06-14 16:07:46 Re: Stopping writes in master
Previous Message Rui DeSousa 2018-06-14 15:20:44 Re: Stopping writes in master