Search Postgresql Archives

Re: Auto vacuum not running -- Could not bind socket for statistics collector

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

 



Hi,

> On December 3, 2014 at 5:04 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> ...
> which suggests that getaddrinfo() preferentially looks in /etc/hosts
> before contacting any DNS server.  So perhaps that "dig" call is not
> telling you the real state of affairs, and what you need to do is
> see if there's a bogus entry for localhost in /etc/hosts.

Thanks a lot, your last hint did the trick!

The /etc/hosts file looked like this on the DB server:

  ::1             localhost ipv6-localhost ipv6-loopback
  192.168.185.41  ixion41.molbi ixion41
  192.168.185.41  ixion41.molbi ixion41

I changed it to this:

  127.0.0.1       localhost
  ::1             ipv6-localhost ipv6-loopback
  192.168.185.41  ixion41.molbi ixion41
  192.168.185.41  ixion41.molbi ixion41


Then I restarted the db server. Now I find this in the logs:
2014-12-03 17:17:53 CET     LOG:  database system was shut down at 2014-12-03
17:17:51 CET
2014-12-03 17:17:53 CET     LOG:  database system is ready to accept connections
2014-12-03 17:17:53 CET     LOG:  autovacuum launcher started


So it seems to work now. Thanks a lot for your time & efforts, Tom Lane!

--
Tim


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[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