Point in time recovery - Mailing list pgsql-general

From
Subject Point in time recovery
Date
Msg-id 20040623041922.881C6D1B173@svr1.postgresql.org
Whole thread Raw
Responses Re: Point in time recovery
List pgsql-general
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 ~




pgsql-general by date:

Previous
From: Joel Matthew
Date:
Subject: Re: Datatype sizes; a space and speed issue?
Next
From: Madison Kelly
Date:
Subject: Re: Datatype sizes; a space and speed issue?