Обсуждение: 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