From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Albert Shih <Albert.Shih@obspm.fr>
To: pgsql-admin@postgresql.org
Subject: Re: pg_xlog
Date: Thu, 11 Feb 2010 16:20:26 -0600
Message-ID: <4B742E4A020000250002F1F4@gw.wicourts.gov> (raw)
In-Reply-To: <20100211220907.GA13352@obspm.fr>
References: <20100211220907.GA13352@obspm.fr>
Albert Shih <Albert.Shih@obspm.fr> wrote:
> How can I clean up the pg_xlog directory ?
>
> I've 710 go of those file.
>
> I've archive_mode on but not in the pg_xlog directory
> I've something like
>
> archive_mode = on # allows archiving to be done
> archive_command = 'cp -i %p /databases/Archives/WAL/%f </dev/null'
It will keep each WAL file until your archive command which is
supposed to copy it completes with an exit code of zero. It sounds
like that's not happening. What does that destination directory
look like? What messages are you seeing in your log files?
> so can I just do
>
> postgresql stop
> rm f pg_xlog/*
> postgresql start
No.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, Albert.Shih@obspm.fr
Subject: Re: pg_xlog
In-Reply-To: <4B742E4A020000250002F1F4@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox