From: | Morus Walter <morus(dot)walter(at)tanto(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Online Backup and WAL archives |
Date: | 2005-02-01 12:59:15 |
Message-ID: | 16895.32035.914311.612690@tanto-xipolis.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Almeida do Lago | 2005-02-01 13:26:13 | Re: Online Backup and WAL archives |
Previous Message | Magnus Hagander | 2005-02-01 10:12:36 | Re: I neen help establishing a connection to my PostgreSQL database. |