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 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match