Skip site navigation (1) Skip section navigation (2)

Re: Backup/Restore to a point in time

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Troy Campano" <troycampano(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Backup/Restore to a point in time
Date: 2004-06-29 15:44:33
Message-ID: 87u0wu2wta.fsf@asmodeus.mcnaught.org (view raw or flat)
Thread:
Lists: pgsql-general
"Troy Campano" <troycampano(at)yahoo(dot)com> writes:

>    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 with current versions.  This feature is called point-in-time
recovery (PITR) and is being reviewed for inclusion in the upcoming
7.5 release.

-Doug

In response to

pgsql-general by date

Next:From: Scott MarloweDate: 2004-06-29 17:13:42
Subject: Re: A few beginner's questions concerning concurrency
Previous:From: Tom LaneDate: 2004-06-29 14:46:51
Subject: Re: Performance problem on RH7.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group