PG_UPGRADE FAILED FROM 9.5 to 11*

Поиск
Список
Период
Сортировка
От Jaspreet Singh
Тема PG_UPGRADE FAILED FROM 9.5 to 11*
Дата
Msg-id BYAPR16MB2789E8E00904B6ED17FE1955BE9B0@BYAPR16MB2789.namprd16.prod.outlook.com
обсуждение исходный текст
Ответы Re: PG_UPGRADE FAILED FROM 9.5 to 11*  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs

Hi Team

We are upgrading our 9.5 postgres database to 11* version and it failed with below error . please help .

 

/usr/pgsql-11/bin/pg_upgrade  -b /usr/pgsql-9.5/bin -B /usr/pgsql-11/bin -d /pgdata/data -D /var/lib/pgsql/11/data/

 

pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 185; 1259 1183792 VIEW pg_stat_activity postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  column pg_stat_activity.waiting does not exist

LINE 27:     "pg_stat_activity"."waiting",

             ^

    Command was:

-- For binary upgrade, must preserve pg_type oid

SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('1183794'::pg_catalog.oid);

 

 

-- For binary upgrade, must preserve pg_type array oid

SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('1183793'::pg_catalog.oid);

 

 

-- For binary upgrade, must preserve pg_class oids

SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('1183792'::pg_catalog.oid);

Thanks & Regards

Jaspreet Singh

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #16497: old and new pg_controldata WAL segment sizes areinvalid or do not match
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16502: EXPLAIN JSON format adds extra quotes around index names