backup, roll forward recovery and log archiving
backup, roll forward recovery and log archiving
От:
"Wang, Yuting" <Yuting@servervault.com>
Дата:
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.
Re: backup, roll forward recovery and log archiving
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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