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(at)multera(dot)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(at)postgresql(dot)org
>

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