On 12/03/2014 12:36 AM, Tim Schäfer wrote:
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?
The below after starting Postgres will show what it successfully bound
to. Not a complete answer but might help narrow the possibilities.
netstat -a | grep postgres
netstat -a | grep <port_number>
Where port_number is the one in postgresql.conf
Also you say you are using pg_ctl to start the program.
What user are you doing that as?
Also any other changes in the Connections portion of postgresql.conf.
Thanks again & greetings,
--
Tim
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
