could not bind socket for statistics collector

[Graham Clarke]

Hi - I'm trying to get postgres 7.4.2 going on RedHat ES

The build went fine but I get the following when trying to start postgres
with this command:

[***@brothers bin]$ ./pg_ctl -D /usr/local/pgsql/data/ -o "-i" start

LOG: could not create IPv6 socket: Address family not supported by protocol
postmaster successfully started
[***@brothers bin]$ LOG: could not bind socket for statistics
collector: C
annot assign requested address
LOG: disabling statistics collector for lack of working socket
LOG: database system was shut down at 2004-05-11 10:12:17 EDT
LOG: checkpoint record is at 0/9B12D8
LOG: redo record is at 0/9B12D8; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 536; next OID: 17142
LOG: database system is ready


Thanks in advance for help & insight into what's going on here.

Cheers
Graham




Graham Clarke
***@53Tech.com
www.53Tech.com
603.643.9955


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Tom Lane]

Post by Graham Clarke
Hi - I'm trying to get postgres 7.4.2 going on RedHat ES
The build went fine but I get the following when trying to start postgres
LOG: disabling statistics collector for lack of working socket

It tries to bind a UDP port to the hostname "localhost". I'm guessing
there is something messed up in your /etc/hosts or DNS configuration,
such that that name doesn't resolve to 127.0.0.1 like it should.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings