Killing inactive connections - Mailing list pgsql-general

From Andrew Gould
Subject Killing inactive connections
Date
Msg-id 20010816202045.30615.qmail@web13404.mail.yahoo.com
Whole thread Raw
Responses Re: Killing inactive connections  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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/

pgsql-general by date:

Previous
From: "Gordon Campbell"
Date:
Subject: Re: DeadLocks
Next
From: "Dr. Evil"
Date:
Subject: Re: Storing images in PG?