Re: pg_xlog directory - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_xlog directory
Date
Msg-id 26772.1136422807@sss.pgh.pa.us
Whole thread Raw
In response to pg_xlog directory  ("Justin W. Reagor" <justin@neteconomist.com>)
List pgsql-novice
"Justin W. Reagor" <justin@neteconomist.com> writes:
> I have three files in /var/lib/pgsql/data/pg_xlog, can I safely remove these
> files?

No.

If the database's usage is as low as the mod dates on the files suggest,
you could reduce the checkpoint_segments parameter and let the system
delete unneeded files.  But removing WAL segments yourself is not only
dangerous but pointless.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Justin W. Reagor"
Date:
Subject: pg_xlog directory
Next
From: Frank Bax
Date:
Subject: Re: Best way to manage users