Skip site navigation (1) Skip section navigation (2)

.backup files not needed?

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: .backup files not needed?
Date: 2008-05-09 06:51:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
Just had questions from a replication user about why the .backup file is
described as "can ordinarily be ignored" and is considered optional by
recovery also even when pg_start_backup() was used.

If the file was created, it is necessary to use it in recovery, so
should never be ignored as the docs imply.

Can we remove the phrase ", and can ordinarily be ignored." ? from

    To make use of the backup, you will need to keep around all the WAL
    segment files generated during and after the file system backup.
    To aid you in doing this, the <function>pg_stop_backup</> function
    creates a <firstterm>backup history file</> that is immediately
    stored into the WAL archive area. This file is named after the first
    WAL segment file that you need to have to make use of the backup.
    For example, if the starting WAL file is
    <literal>0000000100001234000055CD</> the backup history file will be
    named something like
    <literal>0000000100001234000055CD.007C9330.backup</>. (The second
    part of the file name stands for an exact position within the WAL
    file, and can ordinarily be ignored.) Once you have safely archived
    the file system backup and the WAL segment files used during the
    backup (as specified in the backup history file), all archived WAL
    segments with names numerically less are no longer needed to recover
    the file system backup and can be deleted. However, you should
    consider keeping several backup sets to be absolutely certain that
    you can recover your data.

  Simon Riggs


pgsql-docs by date

Next:From: Tom LaneDate: 2008-05-09 14:28:28
Subject: Re: .backup files not needed?
Previous:From: Ian BarwickDate: 2008-05-09 01:29:41
Subject: Re: order of entries in admin docs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group