Обсуждение: Help with Multiple Cluster on same host
Hi, I have 2 cluster databases, running on the same host, Linux with redHat. My fist database port is set to default but my second database port is set to 5436 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 5436, including pgAdmin. Please help. Any parameter that I need to modify for the new database with port 5436?
Jay
The first and most obvious check will be the pg_hba.conf file for the allowed hosts ... these files are specific to the instance.
From: Jacques Lamothe <JLamothe@allconnect.com>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Sent: Wednesday, 21 December 2011 10:02 AM
Subject: [GENERAL] Help with Multiple Cluster on same host
Hi, I have 2 cluster databases, running on the same host, Linux with redHat. My fist database port is set to default but my second database port is set to 5436 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 5436, including pgAdmin. Please help. Any parameter that I need to modify for the new database with port 5436?
Jay
On 12/20/11 1:02 PM, Jacques Lamothe wrote: > Hi, I have 2 cluster databases, running on the same host, Linux with > redHat. My fist database port is set to default but my second database > port is set to 5436 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 5436, including pgAdmin. Please help. > Any parameter that I need to modify for the new database with port 5436? system level firewall? listen_address ? pg_hba.conf settings? -- john r pierce N 37, W 122 santa cruz ca mid-left coast