Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL to get back data in 7.4. - Mailing list pgsql-novice

From Tom Lane
Subject Re: WAL to get back data in 7.4.
Date
Msg-id 23173.1144205316@sss.pgh.pa.us
Whole thread Raw
In response to WAL to get back data in 7.4.  (doris riedl <doris.riedl@univie.ac.at>)
List pgsql-novice
Tree view 
doris riedl <doris.riedl@univie.ac.at> writes:
> I have a postgres version 7.4.
> Today I overwrote some data with an update statement, but only saw it after
> I quit the database.
> Can I use WAL to get back the data? - I know the time of my failure up to
> one minute exact.

Nope, the infrastructure to do that didn't exist before PG 8.0, and even
then it requires keeping backups that you don't have.  Sorry ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Luis Silva"
Date:
Subject: for loop help
Next
From: "A. Kretschmer"
Date:
Subject: Re: for loop help