pg_upgrade fails to restore function

Поиск
Список
Период
Сортировка
От Roger Sunny
Тема pg_upgrade fails to restore function
Дата
Msg-id tencent_53B2FD8658615DD49A364A89C190656E0E06@qq.com
обсуждение исходный текст
Ответы Re: pg_upgrade fails to restore function
Список 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 restore
pg_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 postgres
pg_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

В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: SQL syntax
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_upgrade fails to restore function