From: Tom Lane <tgl@sss.pgh.pa.us>
To: Morus Walter <morus.walter@tanto.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Online Backup and WAL archives
Date: Tue, 01 Feb 2005 12:02:31 -0500
Message-ID: <15479.1107277351@sss.pgh.pa.us> (raw)
In-Reply-To: <16895.32035.914311.612690@tanto-xipolis.de>
References: <16895.32035.914311.612690@tanto-xipolis.de>
Morus Walter <morus.walter@tanto.de> writes:
> 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.
If you are satisfied with recovering to the state shortly after you
completed the backup, then it would be sufficient to have a set of WAL
files spanning the time period in which the backup is done. I'm dubious
that this is necessarily an improvement over a pg_dump backup, though.
> I expect the online backup to faster on recovery than an SQL dump, since
> the latter would imply recreation of indexes during recovery.
Is that assumption founded on any hard evidence?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, morus.walter@tanto.de
Subject: Re: Online Backup and WAL archives
In-Reply-To: <15479.1107277351@sss.pgh.pa.us>
References: <16895.32035.914311.612690@tanto-xipolis.de> <15479.1107277351@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox