Thread: Help with Multiple Cluster on same host

Help with Multiple Cluster on same host

From

Jacques Lamothe

Date:

22 December 2011, 02:51:20

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

Re: Help with Multiple Cluster on same host

From

David Morton

Date:

22 December 2011, 02:57:40

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

Jay

Re: Help with Multiple Cluster on same host

From

John R Pierce

Date:

22 December 2011, 03:01:33

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