Thread: Cannot connect to 2nd cluster database remotely

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

I don’t believe I do. I can connect remotely with my first database that uses the default port 5432 and not with the
secondone using port 5436. However, I can connect locally to the database and perform any task.
 

[root@vpdb1 ~]# iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
[root@vpdb1 ~]#



-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] 
Sent: Wednesday, December 21, 2011 8:52 AM
To: Jacques Lamothe
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cannot connect to 2nd cluster database remotely

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
CertifiedEngineer
 
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org  Twitter:
http://twitter.com/devrimgunduz

On Dec 21, 2011, at 8:26 AM, 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,
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.
Pleasehelp. Any parameter that I need to modify for the new database with port 5436? I have attached the posgresql.conf
file. 

Please share exact error message, you are getting.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com