Online Backup and WAL archives

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

Responses

Browse pgsql-admin by date

  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.