Postgres Pro
Downloads
Home   >   mailing lists

Re: Warm Standby looking for already applied log files - Mailing list pgsql-admin

From Dimitri Fontaine
Subject Re: Warm Standby looking for already applied log files
Date
Msg-id m2sjwdkoy7.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: Warm Standby looking for already applied log files  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Warm Standby looking for already applied log files  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> that script to not delete.   Personally, I like to keep the last two
> base backups and all the WAL files needed to restore from the
> earlier of those forward.  We have  cleanup script that deletes the
> oldest backup and WAL files only needed for recovery from it when we
> receive a new one.

PostgreSQL 9.0 now ships with such a script per default:

  http://www.postgresql.org/docs/9.0/interactive/pgarchivecleanup.html

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-admin by date:

Previous
From: "Frank Brendel"
Date:
Subject: Re: asm/ia64regs.h not found on FreeBSD 8.1 IA64
Next
From: "Kevin Grittner"
Date:
Subject: Re: Warm Standby looking for already applied log files