Almost full pg_xlog/ - Mailing list pgsql-general

From Jeff Ross
Subject Almost full pg_xlog/
Date
Msg-id 4D474698.8070609@wykids.org
Whole thread Raw
Responses Re: Almost full pg_xlog/  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Almost full pg_xlog/  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Hi,

I started trying to setup streaming replication here at work the first
of December but I didn't actually succeed until today.  Too many other
crises to attend to ;-)

In the meantime, I now have 242 16MB files in pg_xlog/.  The
archive_status directory in pg_xlog/has a matching .done file for all
but the most recent of those pg_xlog files.

Am I correct in thinking that I can delete most if not all of the
pg_xlog/ files that have a matching .done entry in
pg_xlog/archive_status/ ?  Or is there a better way?

Sorry in advance if this is in the docs somewhere--I haven't found it yet.

Thanks,

Jeff Ross

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
Next
From: Tom Lane
Date:
Subject: Re: Almost full pg_xlog/