Hi, > On December 2, 2014 at 4:51 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > =?UTF-8?Q?Tim_Sch=C3=A4fer?= <ts+ml@xxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
