Re: Cannot connect to 2nd cluster database remotely - Mailing list pgsql-general

From Devrim GÜNDÜZ
Subject Re: Cannot connect to 2nd cluster database remotely
Date
Msg-id 1324475522.16148.72.camel@lenovo01-laptop03.gunduz.org
Whole thread Raw
In response to Cannot connect to 2nd cluster database remotely  (Jacques Lamothe <JLamothe@allconnect.com>)
Responses Re: Cannot connect to 2nd cluster database remotely
List pgsql-general
On Wed, 2011-12-21 at 13:26 +0000, Jacques Lamothe wrote:
> 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.

Is there a firewall on Linux box? You can check it with

iptables -L

if so, you can stop it with

service iptables stop

and then check again whether the db is accessible remotely or not.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Attachment

pgsql-general by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: can not use the column after rename
Next
From: Jacques Lamothe
Date:
Subject: Re: Cannot connect to 2nd cluster database remotely