On 06/19/2013 01:13 PM, karen chau wrote:
Hi Folks, I'm having trouble with connection / remote connection. I'm running Postgres on Solaris 10. $ netstat -a |grep 5432 localhost.5432 *.* 0 0 49152 0 LISTEN 6002ae2ee98 stream-ord 6002af1d080 00000000 /tmp/.s.PGSQL.5432 _Works fine_ $ psql -d director Welcome to psql 8.1.19 (server 8.2.17), the PostgreSQL interactive terminal. _*Does not work*_ $ psql -h phys-brmtso-2 -d director psql: could not connect to server: Connection refused Is the server running on host "phys-brmtso-2" and accepting TCP/IP connections on port 5432?
Are you connecting locally in both cases or across a network in the second case?
If across a network, might there be a firewall in between blocking connections?
-- 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