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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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