"Troy Campano" <troycampano(at)yahoo(dot)com> writes:
> 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 with current versions. This feature is called point-in-time
recovery (PITR) and is being reviewed for inclusion in the upcoming
In response to
pgsql-general by date
|Next:||From: Scott Marlowe||Date: 2004-06-29 17:13:42|
|Subject: Re: A few beginner's questions concerning concurrency|
|Previous:||From: Tom Lane||Date: 2004-06-29 14:46:51|
|Subject: Re: Performance problem on RH7.1 |