I don’t believe I do. I can connect remotely with my first database that uses the default port 5432 and not with the second one 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@xxxxxxxxxx] Sent: Wednesday, December 21, 2011 8:52 AM To: Jacques Lamothe Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
