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(dot)klaver(at)gmail(dot)com