Results 1 to 3 of 3

Thread: sesion timeout

  1. #1
    Join Date
    Aug 2003

    Unanswered: sesion timeout

    Is there a way to set an inactive connection to expire after a while ?

    If user x have no activity for 5 min the connection to the Postgres will be terminated.

  2. #2
    Join Date
    Oct 2003
    Thers is no setting on server side for time-out connections sitting idle.
    You have to adjust the Apache config directives to allow the httpd
    processes to die and consequently kill the PostgreSQL processes.
    or kill them manually

    $ps aux | grep psql | grep idle

  3. #3
    Join Date
    Aug 2003
    OK, thank you!

    I know that Oracle have something like this...

    I actually have a Connectin Pool with a number of initial conections and a maximum number of connections and i want
    to free the idle connection (the ones that exceed initial number of connections)

    I think that i must put a timestamp on each connection use.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts