Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Rollback using WAL files?
- From: Florian Weimer <fweimer(at)bfk(dot)de>
- To: "M.A. Oude Kotte" <marc(at)solcon(dot)nl>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Rollback using WAL files?
- Date: Fri, 26 Jan 2007 17:59:32 +0100
- Message-id: <82hcud911n(dot)fsf(at)mid(dot)bfk(dot)de>
* 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
- Follow-Ups:
- Re: Rollback using WAL files?
- From: Tom Lane
- Re: Rollback using WAL files?
- References:
- Rollback using WAL files?
- From: M.A. Oude Kotte
- Rollback using WAL files?
- Prev by Date: Re: too many trigger records found for relation "item" -
- Next by Date: Postgresql 8.1: plperl code works with LATIN1, fails with UTF8
- Previous by thread: Re: Rollback using WAL files?
- Next by thread: Re: Rollback using WAL files?
- Indexes: