From: Albert Shih <Albert.Shih@obspm.fr>
To: pgsql-admin@postgresql.org
Subject: pg_xlog
Date: Thu, 11 Feb 2010 23:09:07 +0100
Message-ID: <20100211220907.GA13352@obspm.fr> (raw)
Hi all
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'
so can I just do
postgresql stop
rm f pg_xlog/*
postgresql start
Regards.
JAS
--
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Heure local/Local time:
Jeu 11 fév 2010 23:06:32 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
Subject: Re: pg_xlog
In-Reply-To: <20100211220907.GA13352@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