Обсуждение: could not bind socket for statistics collector

Поиск
Список
Период
Сортировка

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:

[postgres@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
[postgres@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
GrahamC@53Tech.com
www.53Tech.com
603.643.9955


Re: could not bind socket for statistics collector

От
Tom Lane
Дата:
Graham Clarke <grahamc@53tech.com> writes:
> 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:

> 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