From: | Roger Sunny <947035276(at)qq(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Cc: | 我自己的邮箱 <947035276(at)qq(dot)com> |
Subject: | pg_upgrade fails to restore function |
Date: | 2018-03-03 07:08:56 |
Message-ID: | tencent_53B2FD8658615DD49A364A89C190656E0E06@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All
During the pg_upgrade from PostgreSQL 9.4 to PostgreSQL 10.0, the error”[archiver (db)] Error while PROCESSING TOC:” happened, The upgrade failed. OS is RHEL 6.5 , The error is as below:
<pg_upgrade log>pg_restore: connecting to database for restorepg_restore: creating pg_largeobject "pg_largeobject"pg_restore: creating pg_largeobject_metadata "pg_largeobject_metadata"pg_restore: creating SCHEMA "bo_user0300"pg_restore: creating SCHEMA "d0007359_bex2018"pg_restore: creating SCHEMA "d0007359_dan2014" ---- omit ---------- omit ---------- omit ------
pg_restore: creating PROCEDURE "zchuo_ult18.kp_delkakeihyo(character)"
pg_restore: creating FOREIGN DATA WRAPPER "dblink_fdw"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 470023; 2328 777028 FOREIGN DATA WRAPPER dblink_fdw postgrespg_restore: [archiver (db)] could not execute query: ERROR: function dblink_fdw_validator(text[], oid) does not exist
Command was: CREATE FOREIGN DATA WRAPPER "dblink_fdw" VALIDATOR "dblink_fdw_validator";
-- For binary upgrade, handle extension membership the hard way
ALTER EXTENSION "dblink" ADD FOREIGN DATA WRAPPER "dblink_fdw";
Please help to let me know how to address this error?
I appreciate your quick response. Thank you!
Regards,
Roger
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-03-03 15:30:12 | Re: pg_upgrade fails to restore function |
Previous Message | Rob Sargent | 2018-03-03 05:58:45 | Re: SQL syntax |