Re: pg_xlog directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Justin W(dot) Reagor" <justin(at)neteconomist(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_xlog directory
Date: 2006-01-05 01:00:07
Message-ID: 26772.1136422807@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Justin W. Reagor" <justin(at)neteconomist(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2006-01-05 01:02:41 Re: Best way to manage users
Previous Message Justin W. Reagor 2006-01-05 00:51:05 pg_xlog directory