Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3
Дата
Msg-id 20140521144943.GA14030@momjian.us
обсуждение исходный текст
Ответ на Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Tue, May 20, 2014 at 10:25:44PM -0400, Bruce Momjian wrote:
> Find the table that is getting the toast file on the new cluster but not
> the old one, and run all the commands related to that table from the
> dump --- you don't need to load any data, just the schema items.
> 
> Run that on the old cluster and the new cluster, then check if you are
> getting the same case where there is no toast table on the old cluster
> but one on the new cluster.  Remember to only use the 9.3 pg_dump output
> for both old and new clusters.

FYI, you might want to test this by using a different database in the old
cluster so you don't interfere with the existing data.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUGFIX: Dynamic bgworkers with BGW_NEVER_RESTART worker restarted on FatalError
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: buildfarm animals and 'snapshot too old'