|
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? I tried both md5 & trust. phys-brmtso-2# tail -15 pg_hba.conf # superuser. If you do not trust all your local users, use another # authentication method. # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: #host all all 127.0.0.1/32 trust host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 trust # remote connetions: host all all 10.195.1.0/24 md5 |
