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: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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 ?


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: 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-2017 The PostgreSQL Global Development Group