[Pgcluster-general] cluster hangs on dbcreate

Pshem Kowalczyk pshem.k at gmail.com
Wed Jun 20 01:01:31 UTC 2007


Another update, I've noticed on the data nodes, that even though
postgresql binds to the ip address the replication process attaches to
'0.0.0.0':

root at datasql3:/etc/postgresql/8.2/main# netstat -nl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State
tcp        0      0 10.23.254.117:5432    0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:7001            0.0.0.0:*               LISTEN

which is most likely the cause of the problems. How can I force it to
use specific ips only?
The hosts file on that machine:
127.0.0.1       localhost

10.23.254.115   loadbalancer
10.23.254.116   replicator
10.23.254.117   data1
10.23.254.118   data2


# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts


regards
pshem


More information about the Pgcluster-general mailing list