Online Backup and WAL archives
От | Morus Walter |
---|---|
Тема | Online Backup and WAL archives |
Дата | |
Msg-id | 16895.32035.914311.612690@tanto-xipolis.de обсуждение исходный текст |
Ответы |
Re: Online Backup and WAL archives
Re: Online Backup and WAL archives Re: Online Backup and WAL archives |
Список | pgsql-admin |
Hi, I'm currently considering to use postgresql 8.0 online backups. The documentation says ' To make use of this backup, you will need to keep around all the WAL segment files generated at or after the starting time of the backup. ' Now I'm wondering how much of these WAL segment files do I really need in order to recover the databases to a consistent state. Let's say I cannot write the WAL segments to tape dynamically when they are archived. Then a complete disk failure would mean, that I loose WAL segments also. Therefore I would like to save a minimum number of WAL segments at or after the online backup that allows recovery. Is that possible? How would I decide how much of the WAL I need? Of course I could recover to the state of database at about the time of the backup only, but it would be a consistent state at least. Or should I use the previous online backup plus all WAL segements up to the current backup? I expect the online backup to faster on recovery than an SQL dump, since the latter would imply recreation of indexes during recovery. Therefore I would prefer to use online backups. Morus
В списке pgsql-admin по дате отправления: