Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_xlog directory

pg_xlog directory

From
"Justin W. Reagor"
Date:

Hello List,

 

I’m new to Postgres and need alil help cleaning out some files on a system I just started to help maintain. We are looking for files to remove to free up some space.

 

I have three files in /var/lib/pgsql/data/pg_xlog, can I safely remove these files?

 

[root@foobar data]# ls -l /var/lib/pgsql/data/pg_xlog/

total 49212

-rw-------    1 postgres postgres 16777216 Feb  3  2005 000000000000002D

-rw-------    1 postgres postgres 16777216 Jan 26  2005 000000000000002E

-rw-------    1 postgres postgres 16777216 Jan 30  2005 000000000000002F

 

Thanks!

 

Justin W. R.

Re: pg_xlog directory

From
Tom Lane
Date:
"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