backup, roll forward recovery and log archiving

From: "Wang, Yuting" <Yuting(at)servervault(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: backup, roll forward recovery and log archiving
Date: 2003-05-08 21:06:25
Message-ID: 841A2A811DB61840BA6423C08B5735D3073BEB@dulles1.ops.servervault.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wang, Yuting 2003-05-08 21:11:51 backup and roll forward recovery
Previous Message jonesbl 2003-05-08 21:01:31 Support for clustered servers