Re: Problem with connection

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@gmail.com