Re: WAL to get back data in 7.4.
Re: WAL to get back data in 7.4.
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
doris riedl 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
WAL to get back data in 7.4.
От:
doris riedl <doris.riedl@univie.ac.at>
Дата:
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
