[Pkg-postgresql-public] 8.0.3 pg_autovacuum not working
Sat, 04 Jun 2005 18:55:11 +0200
> I've installed Postgresql 8.0.3 on Sarge. The pg server works fine but I
> think the autovacuum daemon doesn't, at least it doesn't log anything.
In the meantime I'm sure that the daemon doesn't work. I did: 'vacuumdb
--all --verbose --analyze' and got such results:
INFO: "dbmail_messages": removed 36465 row versions in 685 pages
DETAIL: CPU 0.11s/0.12u sec elapsed 2.09 sec.
INFO: "dbmail_messages": found 36465 removable, 94241 nonremovable row
versions in 1834 pages
The table hasn't been vacuumed for a long time.
I've set avac_debug=999 (I found no documentation what's the maximum) in
the config but nothing is logged.
If I start the daemon manually logging works:
su postgres -c "/usr/lib/postgresql/8.0/bin/pg_autovacuum -p 5432 -L
/tmp/avc.log -d 999"
Now I'm lost - anyone any idea? Thanks!
http://www.tmueller.com for pgp key (95702B3B)