From: Albert Shih <Albert.Shih@obspm.fr>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_xlog
Date: Thu, 11 Feb 2010 23:43:41 +0100
Message-ID: <20100211224341.GB13434@obspm.fr> (raw)
In-Reply-To: <4B742E4A020000250002F1F4@gw.wicourts.gov>
References: <20100211220907.GA13352@obspm.fr>
<4B742E4A020000250002F1F4@gw.wicourts.gov>
Le 11/02/2010 à 16:20:26-0600, Kevin Grittner a écrit
> 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?
>
Thanks for the help
In fact you right, they are some problem about the copy (wrong owner of the
/WAL directory), so the WAL is not copied. That's why I got ... 45000 files
in the pg_xlog.
Thanks for your help.
Regards.
JAS
--
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Téléphone : 01 45 07 76 26/06 86 69 95 71
Heure local/Local time:
Jeu 11 fév 2010 23:42:11 CET
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: Albert.Shih@obspm.fr, Kevin.Grittner@wicourts.gov
Subject: Re: pg_xlog
In-Reply-To: <20100211224341.GB13434@obspm.fr>
* 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