Postgres Pro
Downloads
Home   >   mailing lists

pg_clogs hanging around - Mailing list pgsql-admin

From Scott Whitney
Subject pg_clogs hanging around
Date
Msg-id 4505952.13818.1299700196217.JavaMail.root@zimbra.int.journyx.com
Whole thread Raw
Responses Re: pg_clogs hanging around  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view
I had this issue back in pg 7.x, and it was resolved by using -a in vacuumdb.

I'm having it again in v8.4.4.

So, my pg_clog directory contains files going back to Jul 13 of 2010.

Every Saturday, I run:

"vacuumdb -a -v -F"


I _thought_ that was supposed to clear those out. Am I wrong?


pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_clogs hanging around