Backup/Restore to a point in time

From: "Troy Campano" <troycampano(at)yahoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Backup/Restore to a point in time
Date: 2004-06-22 20:48:02
Message-ID: 20040622204807.D3D72D1B2D9@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ~

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Heiko Pohl 2004-06-22 20:53:07 Re: Problem while OS-Update
Previous Message Holger Hoffstaette 2004-06-22 20:43:11 Re: 7.5 Windows version