Обсуждение: connection time out
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
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 >
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 >> > > >