Re: [ADMIN] pg_clog not getting cleared

2010-12-22 Thread Scott Whitney
I'm certain it was -f, not -F, since it's still in the script I use, albeit commented out. I understand the purpose of the clogs, but I would think that the transactions would have been frozen on all dbs (I've got about 300 in my cluster) by now. My logs go back to July 13th which, I think,

Re: [ADMIN] pg_clog not getting cleared

2010-12-22 Thread Tom Lane
Scott Whitney sc...@journyx.com writes: I understand the purpose of the clogs, but I would think that the transactions would have been frozen on all dbs (I've got about 300 in my cluster) by now. My logs go back to July 13th which, I think, is when the server was last restarted. It

[ADMIN] pg_clog not getting cleared

2010-12-21 Thread Scott Whitney
Hello. I posted this once before, but I'm encountering it again. Each Saturday, I run: vacuumdb -a -v. I have autovac on all the time. However, my pg_clog directory lists clog files going back to July. This is pg 8.4.4 on Linux (CentOS 5.5). I know this isn't a whole lot of information at

Re: [ADMIN] pg_clog not getting cleared

2010-12-21 Thread Kevin Grittner
Scott Whitney sc...@journyx.com wrote: Each Saturday, I run: vacuumdb -a -v. I have autovac on all the time. However, my pg_clog directory lists clog files going back to July. This is pg 8.4.4 on Linux (CentOS 5.5). I know this isn't a whole lot of information at this time. What