| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Tory M Blue *EXTERN*" <tmblue(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PG_XLOG 27028 files running out of space |
| Date: | 2013-02-14 11:09:25 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B057B33E8@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Tory M Blue wrote:
> My postgres db ran out of space. I have 27028 files in the pg_xlog directory. I'm unclear what
> happened this has been running flawless for years. I do have archiving turned on and run an archive
> command every 10 minutes.
>
> I'm not sure how to go about cleaning this up, I got the DB back up, but I've only got 6gb free on
> this drive and it's going to blow up, if I can't relieve some of the stress from this directory over
> 220gb.
> Postgres 9.1.6
> slon 2.1.2
Are there any messages in the log file?
Are you sure that archiving works, i.e. do WAL files
show up in your archive location?
The most likely explanation for what you observe is that
archive_command returns a non-zero result (fails).
That would lead to a message in the log.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tory M Blue | 2013-02-14 11:11:05 | Re: PG_XLOG 27028 files running out of space |
| Previous Message | Heikki Linnakangas | 2013-02-14 11:08:58 | Re: PG_XLOG 27028 files running out of space |