pg_upgrade - link mode and transaction-wraparound data loss - Mailing list pgsql-hackers

From jesper@krogh.cc
Subject pg_upgrade - link mode and transaction-wraparound data loss
Date
Msg-id 47c04e8c42e50ad2c63975cbf9c3cfb4.squirrel@shrek.krogh.cc
Whole thread Raw
Responses Re: pg_upgrade - link mode and transaction-wraparound data loss
List 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 by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Synchronous replication patch built on SR
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Clarifications of licences on pgfoundry