Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
vacuum from several weeks ago, and this is an active db. Also, I see no
vacuum activity in the logs. But "show autovacuum" does show it being
on....
So if it is running after all, how can I track down why things aren't
getting vacuumed? What log level are the autovacuum logs at?
On Tue, 28 Aug 2007, Alvaro Herrera wrote:
Ben wrote:
My autovacuum daemon isn't running on 8.2.4, and I'm guessing it's because
I changed my unix socket directory in postgresql.conf. Is there a way I can
tell autovacuum which socket file to use, or which IP to connect to?
It doesn't use a socket. How do you know it's not running? An easy
test is connect with psql and do a "show autovacuum". If it's on, then
it is running.
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
