Re: backup, roll forward recovery and log archiving

We are working on this for 7.4, due out early Fall.

---------------------------------------------------------------------------

Wang, Yuting wrote:
> Hi, there:
>
> I am a new user of PostgreSQL. I am trying find out whether I can do, and if
> so,  how to do a roll forward recovery from a backup. It seems that the 7.3
> release does not provide mechanisms to perform a hot backup, to archive
> logs, and to apply the archived logs for a recovery. I saw a patch(pg_copy)
> for roll forward recovery in a post from richt@multera.com, I don't know
> whether this is implemented yet. So if I perform nightly export with
> pg_dump, and there is a datafile corruption in the afternoon, then my only
> choice would be to restore from the dump, and lose all the transactions
> between the dump and the point of failure. Am I right? I'd really appreciate
> it if anyone can provide some inside into this issue. Thanks a million.
>
> Yuting Wang
> ServerVault Co.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  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