Please HELP - URGENT - transaction wraparound error

From: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Please HELP - URGENT - transaction wraparound error
Date: 2005-10-30 08:50:18
Message-ID: 4364894A.5000209@wardbrook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oh my god!....

DB is pg 7.4.6 on linux

2005-10-27 05:55:55 WARNING: some databases have not been vacuumed in
2129225822 transactions
HINT: Better vacuum them within 18257825 transactions, or you may have
a wraparound failure.

2005-10-28 05:56:58 WARNING: some databases have not been vacuumed in
over 2 billion transactions
DETAIL: You may have already suffered transaction-wraparound data loss.

We have cronscripts that perform FULL vacuums

# vacuum template1 every sunday
35 2 * * 7 /usr/local/pgsql/bin/vacuumdb --analyze --verbose template1

# vacuum live DB every day
35 5 * * * /usr/local/bin/psql -c "vacuum verbose analyze" -d bp_live -U
postgres --output /home/postgres/cronscripts/live/vacuumfull.log

Questions:

1) Why do have we data corruption? I thought we were doing everything we
needed to stop any wraparound... Are the pg docs inadequate, or did I
misunderstand what needed to be done?

2) What can I do to recover the data?

I have full daily backups from midnight each day using
/usr/local/pgsql/bin/pg_dump $DATABASE > $BACKUPFILE

plus I have this database replicated using Slon 1.1.0 to another 7.4.6
database.

I can failover to the slave server, but what do I need to do to rebuild
the original database?

Should I failover now?!! And then start rebuilding the old master
database (using slon, I presume)?

How do I stop this EVER happening again??!!!

Thanks for help

John

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-10-30 13:56:31 Re: Please HELP - URGENT - transaction wraparound error
Previous Message A. Kretschmer 2005-10-30 07:45:53 Re: function example?