Thread: Restore-point?

Restore-point?

From
"Philippe Lang"
Date:
Hello,

Sorry if this post was sent twice.

Is it possible to restore a database previously backed-up with "dump", and then recover some of the changes made after
thebackup, until a specific timestamp, by using some sort of "journal"? Is there such a feature in Postgresql? 

Thanks

-------------------------
Philippe Lang
Attik System
http://www.attiksystem.ch


Re: Restore-point?

From
Bruce Momjian
Date:
Philippe Lang wrote:
> Hello,
>
> Sorry if this post was sent twice.
>
> Is it possible to restore a database previously backed-up with
> "dump", and then recover some of the changes made after the
> backup, until a specific timestamp, by using some sort of
> "journal"? Is there such a feature in Postgresql?

You are asking for point-in-time recovery.  We are working on adding
that, maybe for 7.5.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073