Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"

Alexandre Leclerc <aleclerc(at)ipso(dot)ca> wrote:

> our customer is supposed to have a full file backup from the
> evening.

That's very good news, but given that they've not been going "by the
book" in all respects, it pays to be cautious here. Did they make
the copy while the database service was shut down? If not, did they
follow all the rules for a PITR backup?

http://www.postgresql.org/docs/8.1/interactive/backup.html

In any event, take great care that the backup is not overwritten,
deleted, or *moved* to be used for recovery. You really want to
protect that and keep it until the database has been up and running
for a few weeks, at least.

-Kevin