<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">

<h1><aname="section_1">PostgreSQL TODO List</a></h1>

<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>

Last updated: Mon Apr 1810:42:34 EDT 2005

Last updated: Mon Apr 1811:03:14 EDT 2005

<p>The most recent version of this document can be viewed at the PostgreSQL web<br/>

site,<ahref="http://www.PostgreSQL.org">http://www.PostgreSQL.org</a>.

logs

<p> Currently only full WAL files are archived. This means that the most

recent transactions aren't available for recovery in case of a disk

failure.

failure. This could be triggered by a user command or a timer.

</li><li>Forcearchiving of partially-full WAL files whenpg_stop_backup() is

called or the server is stopped

</li><li>Automatically forcearchiving of partially-filled WAL files when

pg_stop_backup() iscalled or the server is stopped

<p> Doing this will allow administrators to know more easily when the

archive contins all the files needed for point-in-time recovery.

<!--

$PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.63 2005/04/1813:11:04 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.64 2005/04/1817:40:40 momjian Exp $

-->

<chapter id="backup">

<title>Backup and Restore</title>

<literal>0000000100001234000055CD.007C9330.backup</>. (The second

number in the file name stands for an exact position within the WAL

file, and can ordinarily be ignored.) Once you have safely archived

the WAL segment files used during thefile system backup (as

specified in the backup history file), you can delete allarchived

WAL segments with names numerically less. Keep in mind thatonly

completed WAL segment files are archived, so there will be delay

thefile system backup and theWAL segment files used during the

backup (asspecified in the backup history file), you can delete all

archivedWAL segments with names numerically less. Keep in mind that

onlycompleted WAL segment files are archived, so there will be delay

between running <function>pg_stop_backup</> and the archiving of

all WAL segment files needed to make the file system backup

consistent.