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
postgresql
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