Cannot connect to 2nd cluster database remotely

Started by Jacques Lamotheover 14 years ago2 messagesgeneral
Jump to latest
#1Jacques Lamothe
JLamothe@allconnect.com

Hi, I have 2 cluster databases, running on the same host, Linux with redHat. My fist database port is set to default, 5432, but my second database port is set to 5436 in the postgresql.conf file. While everything is ok with local connections, I cannot connect remotely 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? I have attached the posgresql.conf file.

Jay

#2Jasen Betts
jasen@xnet.co.nz
In reply to: Jacques Lamothe (#1)
Re: Cannot connect to 2nd cluster database remotely

On 2011-12-22, Jacques Lamothe <JLamothe@allconnect.com> wrote:
[..]

While everything is ok with local connections, I cannot connect remotely
using any of my tools to the second database with port 5436,

[...]

I have attached the posgresql.conf file.

It fell off.

The line you want is "listen_addresses"

--
⚂⚃ 100% natural