Обсуждение: backup and roll forward recovery
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.
On Thu, May 08, 2003 at 05:11:51PM -0400, 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 7.3 does do hot backup (with pg_dump). But this is a snapshot backup, and there is no roll forward capability. It is currently being worked on, and may be integrated in 7.4, which will go into feature freeze sometime in the next little while (perhaps before July 1, to read -hackers lately). A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M2P 2A8 +1 416 646 3304 x110