WAL to get back data in 7.4.

From: doris riedl <doris(dot)riedl(at)univie(dot)ac(dot)at>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: WAL to get back data in 7.4.
Date: 2006-04-04 22:34:15
Message-ID: C058C107.225E%doris.riedl@univie.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(dot)riedl(at)univie(dot)ac(dot)at

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luis Silva 2006-04-04 23:01:02 for loop help
Previous Message Tomeh, Husam 2006-04-04 21:55:37 Re: Semaphore trouble for installation