Search Postgresql Archives

Re: cleaning wal files from postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello.

When you execute pg_stop_backup,postgresql makes a special file, like this
000000010000000000000015.00000064.backup.

This means you can delete wal 000000010000000000000014 and before.

The PostgreSQL manual also says following.

http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html#BACKUP-ARCHIVING-WAL

24.3.2. Making a Base Backup

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 pg_stop_backup function creates a 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 0000000100001234000055CD the backup history file will be named something like 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.


Thank you.


oops, sorry, my question was very ambiguous ...
What I want to know is:
The correct procedure to remove the wal files that have been used in the recovery of a postgres server.


Consider the following;

1.-  A main server in production.
2.- A  secondary server that is normally off.
3.- By connecting the secondary server, the primary server must copy the directory data as well as wal files generated during the copying process.

4.- start up  the postgres on the secondary server.

5o.Delete wal files no longer will be used by postgres to save disk space.

how can i know which wal file is not required by postgres and delete wal files from main and secondary server, to save space disk on the servers ? (after a succesfully start up on secondary server)


regards eddie.

On 05/21/2010 03:43 PM, Andreas Schmitz wrote:

maybe I don't understand the problem. there is no need to clean WAL files after recovery. where exactly is the problem ?

regards

andreas


erobles wrote:

 PITR  recovery

On 05/21/2010 03:04 PM, Andreas Schmitz wrote:
erobles wrote:
which is the right procedure to clean wal files after a  recovery ??
what kind of recovery ?

regards

andreas







--
================================================
Kenichiro Tanaka
K.K.Ashisuto
http://www.ashisuto.co.jp/english/index.html
================================================


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux