[Pkg-postgresql-public] 8.0.3 pg_autovacuum not working

[Thomas Mueller]

Hi,

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 postgresql.conf I've set:
stats_start_collector = true
stats_row_level = true

In autovacuum.conf I've left the defaults and tried:
avac_debug=2

The pg_autovacuum daemon is running, but after days the logfile is still
empty.

An attached strace shows the daemon is connecting and doing queries
(some lines skipped):
connect(0, {sa_family=AF_FILE, path="/tmp/.s.PGSQL.5432"}, 110) = 0
send(0, "\0\0\0)\0\3\0\0user\0postgres\0database\0p"..., 41, 0) = 41
send(0, "Q\0\0\0\316select a.oid,a.relname,a.re"..., 207, 0) = 207
recv(0, "T\0\0\1\33\0\noid\0\0\0\4\353\377\376\0\0\0\32\0\4\377"...,
16384, 0) = 3569
send(0, "Q\0\0\0\316select a.oid,a.relname,a.re"..., 207, 0) = 207
recv(0, "T\0\0\1\33\0\noid\0\0\0\4\353\377\376\0\0\0\32\0\4\377"...,
16384, 0) = 3569
send(0, "X\0\0\0\4", 5, 0)              = 5
close(0)                                = 0

In the postgresql log I see lots of lines like this one:
LOG:  incomplete startup packet
Could that be the autovacuum daemon?

Thanks!


Thomas
-- 
http://www.tmueller.com for pgp key (95702B3B)