Re: Online Backup and WAL archives

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Re: Online Backup and WAL archives

Tom Lane-2
Morus Walter <[hidden email]> 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?