backup, roll forward recovery and log archiving - Mailing list pgsql-admin

From Wang, Yuting
Subject backup, roll forward recovery and log archiving
Date
Msg-id 841A2A811DB61840BA6423C08B5735D3073BEB@dulles1.ops.servervault.com
Whole thread Raw
Responses Re: backup, roll forward recovery and log archiving  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: gunther hust
Date:
Subject: eRserver
Next
From: "Jason Kosowan"
Date:
Subject: Problem upgrading PGSQL7.3.2 from PGSQL6.5 under RHLinux6.5 - missing global/pg_control