Problem with connection - Mailing list pgsql-general

From karen chau
Subject Problem with connection
Date
Msg-id 51C210EC.7060707@oracle.com
Whole thread Raw
Responses Re: Problem with connection  (Ziggy Skalski <zskalski@afilias.info>)
Re: Problem with connection  (Adrian Klaver <adrian.klaver@gmail.com>)
List 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


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Migration from DB2 to PostgreSQL-ROLLUP()
Next
From: Ziggy Skalski
Date:
Subject: Re: Problem with connection