Thread: Disconnect/Resource releasing/PING

Hi!

Many databases (like Firebird) have some time limitation for the clients.

These cases possible with client:

a.) It is working, but network connection is temp. down.

b.) The client is crashing

c.) The client is on, but it is not working for N minutes.

When the server experience that client is not speaking in N minutes, the handle and all resources will be freed.

I want to know about this case in PG.

1.) Do I need to PING the server periodically N minutes with "select time()" query to keep the handle live?

2.) What happened, if client crashed, or died? WHen the resources (temp tables, cursors, etc) freed?

3.) Can I configure this per databases, or only per server?

4.) If I use PGDAC or ZEOS to access PG are them make this PING automatically?

5.) What happens if a client died but it's query (long) is running? Is query cancelled by the server, or wait for finish?

6.) If a long query running the client can got timeout because it is cannot work?

Thanks for your help:

   dd