postgresql 9.1 Multiple Cluster on same host

Posted by user1272305 on Server Fault See other posts from Server Fault or by user1272305
Published on 2012-10-19T08:12:37Z Indexed on 2012/10/19 11:08 UTC
Read the original article Hit count: 232

Filed under:

I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port is set to 5433 in the postgresql.conf file. While everything is ok with local connections, I cannot connect using any of my tools to the second database with port 5433, including pgAdmin. Please help. Any parameter that I need to modify for the new database with port 5433?

netstat -an | grep 5433 shows,

tcp 0 0 0.0.0.0:5433 0.0.0.0:* LISTEN 
tcp6 0 0 :::5433 :::* LISTEN 
unix 2 [ ACC ] STREAM LISTENING 72842 /var/run/postgresql/.s.PGSQL.5433

iptables -L shows,

Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination

© Server Fault or respective owner

Related posts about postgresql