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