Point in time recovery
Hello,
1) I know that PostgreSQL writes its transactions to logs (WAL).
If I take exports once a day (say 7am) and I have a client that somehow
ruins their database at 5pm today and it is now 7pm, can I somehow get the
database back to the state it was in at 4:59 (right before they blew up
their database)?
2) Where are the WAL files located?
Thank you!
~ Troy Campano ~
postgresql@troygeek.com wrote:
Hello,
1) I know that PostgreSQL writes its transactions to logs (WAL).
If I take exports once a day (say 7am) and I have a client that somehow
ruins their database at 5pm today and it is now 7pm, can I somehow get the
database back to the state it was in at 4:59 (right before they blew up
their database)?
Not yet. Point-in-time-recovery (PITR) looks like it will be in 7.5,
which will be entering beta testing fairly soon.
2) Where are the WAL files located?
Next to your data files in pg_xlog.
--
Richard Huxton
Archonet Ltd