pg_upgrade - link mode and transaction-wraparound data loss

Поиск
Список
Период
Сортировка
От jesper@krogh.cc
Тема pg_upgrade - link mode and transaction-wraparound data loss
Дата
Msg-id 47c04e8c42e50ad2c63975cbf9c3cfb4.squirrel@shrek.krogh.cc
обсуждение исходный текст
Ответы Re: pg_upgrade - link mode and transaction-wraparound data loss  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Hi

I tried running pg_upgrade from the current snapshot of postgresql and
upgrading from 8.4.4 to the snapshot version. Everything seem to look fine
in the process and all that came out was only "ok's" but when I tried a
simple query on the databse it keeps throwing these message out of the back
side.

DETAIL:  You might have already suffered transaction-wraparound data loss.
WARNING:  some databases have not been vacuumed in over 2 billion
transactions


The database was around 600GB and it took a couple of minutes to run
pg_upgrade after I had all the binaries in the correct place.

It is not really an easy task to throw around 600GB of data, so I cannot
gaurantee that the above is reproducible, but I'll see if I can get time
and try to reproduce it.

Jesper



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Synchronous replication patch built on SR
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Clarifications of licences on pgfoundry