Hot Backup
От | Sandeep Chadha |
---|---|
Тема | Hot Backup |
Дата | |
Msg-id | 4AFE42D73ED1F345A576D3290FF8421C17674A@exchange.nnco.net обсуждение исходный текст |
Ответы |
Point in Time Recovery WAS: Hot Backup
|
Список | pgsql-general |
Hello to all the Doers of Postgres!!! Last time I went through forums, people spoke highly about 7.3 and its capability to do hot backups. My problem is if thedatabase goes down and I lose my main data store, then I will lose all transactions back to the time I did the pg_dump. Other databases (i e Oracle) solves this by retaining their archive logs in some physically separate storage. So, when youlose your data, you can restore the data from back-up, and then apply your archive log, and avoid losing any committedtransactions. Postgresql has been lacking this all along. I've installed postgres 7.3b2 and still don't see any archive's flushed to anyother place. Please let me know how is hot backup procedure implemented in current 7.3 beta(2) release. Thanks.
В списке pgsql-general по дате отправления: