pg_xlog

From: Albert Shih <Albert(dot)Shih(at)obspm(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_xlog
Date: 2010-02-11 22:09:07
Message-ID: 20100211220907.GA13352@obspm.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

  • Re: pg_xlog at 2010-02-11 22:20:26 from Kevin Grittner
  • Re: pg_xlog at 2010-02-11 22:24:37 from Joshua D. Drake

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-02-11 22:20:26 Re: pg_xlog
Previous Message Jaime Casanova 2010-02-11 19:48:12 Re: REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Linux