On 12/27/2011 11:07 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. Please help. Any parameter that I need to modify for the new
database with port 5436? I have attached the posgresql.conf.
My guess is it is one of two things:
1) Did you restart the server after changing the value for listen_addresses?
2) Have you looked at the pg_hba.conf file to see if it allows remote
connections?
http://www.postgresql.org/docs/9.0/interactive/auth-pg-hba-conf.html
Jay
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
