backup and roll forward recovery
От | Wang, Yuting |
---|---|
Тема | backup and roll forward recovery |
Дата | |
Msg-id | 841A2A811DB61840BA6423C08B5735D3073BEC@dulles1.ops.servervault.com обсуждение исходный текст |
Ответы |
Re: backup and roll forward recovery
|
Список | 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 по дате отправления: