pg_upgrade - link mode and transaction-wraparound data loss

From: jesper(at)krogh(dot)cc
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_upgrade - link mode and transaction-wraparound data loss
Date: 2010-05-18 13:11:40
Message-ID: 47c04e8c42e50ad2c63975cbf9c3cfb4.squirrel@shrek.krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-05-18 13:22:02 Re: Clarifications of licences on pgfoundry
Previous Message Fujii Masao 2010-05-18 11:41:58 Re: Synchronous replication patch built on SR