| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | "M(dot)A(dot) Oude Kotte" <marc(at)solcon(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Rollback using WAL files? |
| Date: | 2007-01-26 16:59:32 |
| Message-ID: | 82hcud911n.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* M. A. Oude Kotte:
> I'm running a production/development database using PostgreSQL 8.1 on a
> Debian server. Due to some bad code in one of our applications who use
> this database, some of the data was modified incorrectly the last few
> days. The idea is that I would like to restore the entire database as
> much as possible, meaning I would like to undo all transactions that
> were performed on it.
In theory, this should be possible (especially if you haven't switched
off full page writes). But I don't know a ready-made solution for
this kind of task.
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe Lang | 2007-01-26 17:17:03 | Postgresql 8.1: plperl code works with LATIN1, fails with UTF8 |
| Previous Message | Tom Lane | 2007-01-26 16:45:10 | Re: too many trigger records found for relation "item" - |