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

Hi,

> On December 2, 2014 at 4:51 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> =?UTF-8?Q?Tim_Sch=C3=A4fer?= <ts+ml(at)rcmd(dot)org> writes:
> > After starting the server with pg_ctl start, I get the following entries in
> > the
> > logs:
>
> > 2014-12-02 15:27:36 CET LOG: could not bind socket for statistics
> > collector: Cannot assign requested address
> > 2014-12-02 15:27:36 CET LOG: disabling statistics collector for lack of
> > working socket
>
> Yes, this will break autovacuum, because it won't have any way to find out
> what it should vacuum. The cause probably is a DNS issue: "localhost"
> isn't resolving to anything sensible. "dig localhost" on the command line
> might offer some insight.

thanks for your answer. Here is my full 'dig localhost' from the database
server:

~/data> dig localhost

; <<>> DiG 9.9.4-rpz2.13269.14-P2 <<>> localhost
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 10157
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 1, ADDITIONAL: 2

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4096
;; QUESTION SECTION:
;localhost. IN A

;; ANSWER SECTION:
localhost. 604800 IN A 127.0.0.1

;; AUTHORITY SECTION:
localhost. 604800 IN NS localhost.

;; ADDITIONAL SECTION:
localhost. 604800 IN AAAA ::1

;; Query time: 1 msec
;; SERVER: 192.168.185.11#53(192.168.185.11)
;; WHEN: Wed Dec 03 09:24:53 CET 2014
;; MSG SIZE rcvd: 96

Looks fine to me. Or is there something wrong with it?

And are you sure pgsql is unhappy with localhost? It would be great if I
definitely knew the address it is trying to bind. Is there a way to tell?

Thanks again & greetings,

--
Tim