Re: connection time out

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Bakos Sandor <dr_saca(at)freemail(dot)hu>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: connection time out
Date: 2006-05-18 11:02:55
Message-ID: 4C64C4F5-DFC9-46EC-BFC0-035204E67F10@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

Check your pg_hba.conf file. Java typically will connect from the
main ethernet address where as psql connects from localhost.

Dave
On 17-May-06, at 11:13 AM, Bakos Sandor wrote:

> Hi All!
>
> I have a linux clinet which connect to the remote posgtresql on a
> linux too with a java GUI application.
> This application read an write the database when a blockout occurs.
> In this situation the java application
> leave many connection in the postgresql (about 30). When the client
> is restarting and try to connect to the database I get an
> exception:
>
> Caused by: java.net.ConnectException: Connection timed out
>
> but the max connection in the server is 200. From the console I can
> create many connection to the server (psql) just the java can't.
>
> Someone have an idea ?
>
> (postgresql 8, java 1.5)
>
> Thx.
> Saca
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bakos Sandor 2006-05-18 11:41:02 Re: connection time out
Previous Message Markus Schaber 2006-05-18 09:41:10 Re: error : could not access status of transaction