Re: Database Recovery

--- Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> wrote:
> > http://www.hjackson.org/blog/archives/2004/12/postgresql_data.html
>
> Huh, this sounds like transaction Id wraparound to me. Do you
> regularly run vacuums on the whole database? Did you ask for expert
> help on the lists before running to do whatever you did?

I didn't run to do anything ;) I had a good think and a good google
before I done anything and I have all my data back because of it.
Luckily for me the data was neither life or job threatening so I was
able to take a few more risks than necessary. I was actually
volunteering to write the database recovery section of the docs, not
asking for help.

As per TID wraparound. I have been lucky enough never to have received
anything similar to the following warning (taken from 7.4 docs)

play=# vacuum;
WARNING: Some databases have not been vacuumed in 1613770184
transactions.
Better vacuum them within 533713463 transactions,
or you may have a wraparound failure.
VACUUM

you will also notice that I used a TID of less than 100 million to
recover the database. I was nowhere near 0.5 billion as recommended by
the docs.

Harry

=====
Harry
Join team plico.
http://www.hjackson.org/cgi-bin/folding/index.pl

__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250