Re: Prolem to acess PostgeSQL from other mechine

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: Arun R T <arunrt99(at)ymail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Prolem to acess PostgeSQL from other mechine
Date: 2012-09-24 16:24:53
Message-ID: 50608955.9080804@boscorama.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rachel Owsley 2012-09-24 16:32:25 N-tile function in postgres
Previous Message Adrian Klaver 2012-09-24 15:07:34 Re: Prolem to acess PostgeSQL from other mechine