Skip site navigation (1) Skip section navigation (2)

Re: connection time out

From: Bakos Sandor <dr_saca(at)freemail(dot)hu>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: connection time out
Date: 2006-05-18 11:41:02
Message-ID: 446C5D4E.2010802@freemail.hu (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

I don't understand this. When I would like connect again to the server 
(after the blackout) I can connect from the client to the server
from psql but the Java can't. In this case no connection from the 
localhost. What can I set in the pg_hba.conf ?

Saca

Dave Cramer wrote:
> 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

pgsql-jdbc by date

Next:From: Alexandre de Arruda PaesDate: 2006-05-18 22:11:35
Subject: Automatic cast
Previous:From: Dave CramerDate: 2006-05-18 11:02:55
Subject: Re: connection time out

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group