| From: | karen chau <karen(dot)chau(at)oracle(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Problem with connection |
| Date: | 2013-06-19 20:13:32 |
| Message-ID: | 51C210EC.7060707@oracle.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ziggy Skalski | 2013-06-19 20:53:17 | Re: Problem with connection |
| Previous Message | Merlin Moncure | 2013-06-19 18:59:11 | Re: Migration from DB2 to PostgreSQL-ROLLUP() |