Search Postgresql Archives

Re: autovacuum not running

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux