Re: Help with Multiple Cluster on same host

From: David Morton <davidmorton(at)xtra(dot)co(dot)nz>
To: Jacques Lamothe <JLamothe(at)allconnect(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help with Multiple Cluster on same host
Date: 2011-12-22 03:57:18
Message-ID: 1324526238.92023.YahooMailNeo@web96002.mail.aue.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)allconnect(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-12-22 03:59:22 Re: Cursor loop - stop current iteration and continue with next iteration
Previous Message Yan Chunlu 2011-12-22 02:12:58 Re: ignore duplicate key while using COPY?