Restore-point?

Started by Philippe Langover 22 years ago2 messagesgeneral
Jump to latest
#1Philippe Lang
philippe.lang@attiksystem.ch

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?

Thanks

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Philippe Lang (#1)
Re: Restore-point?

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