Re: Problem with connection

On 13-06-19 04: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?
>
> 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
>
>

Hi,

Check this line in your postgresql.conf maybe?

#listen_addresses = 'localhost' # what IP address(es) to listen on;

You should have it set to localhost *and* the hostname you want to use
(i.e. the phys-brmtso-2), that might be the problem I think.

Ziggy