Re: 2,2gb of pg_xlog ?? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: 2,2gb of pg_xlog ??
Date
Msg-id 20060622140304.GJ29883@surnet.cl
Whole thread Raw
In response to Re: 2,2gb of pg_xlog ??  ("Andy Shellam" <andy@andycc.net>)
Responses Re: 2,2gb of pg_xlog ??  ("Andy Shellam" <andy@andycc.net>)
List pgsql-admin
Andy Shellam wrote:

> Archive_command = "mv %p /your/backup/directory/%f"

Don't do this.  Postgres itself will remove the file after the
archive_command has copied it elsewhere.

> Tip: if you're absolutely sure you will never need these transaction logs,
> you can use the following command to delete them when they're finished with:
>
> Archive_command = "rm -f %p"

Don't do this either.  If you're not using PITR, just set a blank
archive_command and Postgres will delete the file as soon as it's not
needed anymore.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Question on failure during cluster operation
Next
From: "Chris Hoover"
Date:
Subject: Re: 2,2gb of pg_xlog ??