Thread: WAL to get back data in 7.4.

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.
If yes how do I do this? The documentation (I have read everything on WAL,
but still have no clue how to start - especially when to design the
recovery.config-file) was no big help to me until now.

Regards
Doris
--
Mag. Doris Riedl
Institut für Geographie und Regionalforschung
der Universität Wien
A-1010 Wien, Universitätsstraße 7
Tel.: ++43-1-4277-48654
Fax:  ++43-1-4277-48649
E-mail: doris.riedl@univie.ac.at

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