Thread: 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