Re: Prolem to acess PostgeSQL from other mechine - Mailing list pgsql-general

From Bosco Rama
Subject Re: Prolem to acess PostgeSQL from other mechine
Date
Msg-id 50608955.9080804@boscorama.com
Whole thread Raw
In response to Prolem to acess PostgeSQL from other mechine  (Arun R T <arunrt99@ymail.com>)
List pgsql-general
On 09/23/12 20:50, Arun R T wrote:
>
> I have some problem to connect PostgeSQL server from client mechine
[snip]
> org.postgresql.util.PSQLException: Connection refused. Check that the hostname
> and port are correct and that the postmaster is accepting TCP/IP connections.

Given this ^^^ follow the recommendations:  Check that you are talking to the
correct host (10.10.10.101).  Then check that you have the right port number
(you had 6060 but you didn't mention that you had changed it from the default
which is usually 5432 for the first PG instance on a machine).  You indicated
that you had enabled listening for tcp on all addresses.  Did you (re)start
the server afterwards?

As a final act of desperation, make sure there is no intervening firewalls/routers
that may be rejecting it.

HTH

Bosco.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Prolem to acess PostgeSQL from other mechine
Next
From: Rachel Owsley
Date:
Subject: N-tile function in postgres