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

Re: Warm Standby looking for already applied log files

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Colin Wilson" <cwilson(at)blackducksoftware(dot)com>, "pgsql-admin\(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Warm Standby looking for already applied log files
Date: 2011-01-28 15:50:08
Message-ID: m2sjwdkoy7.fsf@2ndQuadrant.fr (view raw or flat)
Thread:
Lists: pgsql-admin
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2011-01-28 16:01:59
Subject: Re: Warm Standby looking for already applied log files
Previous:From: Frank BrendelDate: 2011-01-28 15:27:18
Subject: Re: asm/ia64regs.h not found on FreeBSD 8.1 IA64

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