I've tried to use PostgreSQL over ISDN lines with about a timeout
of ~60 seconds - when no traffic is done, the line is dropped.
Actually I've done several tests under Linux with Adabas-D and
I was *very* surprised to see, that the application was working
with the database without any problems - even when the line
was dropped. No problem at all .. for the next query the
isdn line was build up again, the query was done and it hanged
up again after timeout ...
PostgreSQL seems to have *many* problems with it:
1) The system can not connect to the database, because of the time
the isdn line needs to build up the connection.
2) After the line was dropped, the application was not able to
use the connection to the database for further work.
What could be done against such behaviour ?
Marten