Killing inactive connections

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Postgres Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Killing inactive connections
Date: 2001-08-16 20:20:45
Message-ID: 20010816202045.30615.qmail@web13404.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I run a clinical data warehouse using PostgreSQL
7.1.2_2 on FreeBSD 4.3-stable. Data security and
privacy standards have been enacted at the federal
level via the Health Insurance Portability and
Accountability Act (HIPAA).

One of the rules requires timed logouts. If someone
walks away from their desk for a certain amount of
time, the connection should time-out; and the employee
must log back into the application.

Data analysts access my databases using MS Access. Is
there a way in PostgreSQL to track inactivity and
close inactive connections after a specified length of
time?

Thanks,

Andrew Gould

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2001-08-16 20:39:36 Re: unix timestamp
Previous Message Tom Lane 2001-08-16 20:06:07 Re: Re[2]: Perfomance decreasing