Killing inactive connections

Поиск
Список
Период
Сортировка
От Andrew Gould
Тема Killing inactive connections
Дата
Msg-id 20010816202045.30615.qmail@web13404.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Killing inactive connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Gordon Campbell"
Дата:
Сообщение: Re: DeadLocks
Следующее
От: "Dr. Evil"
Дата:
Сообщение: Re: Storing images in PG?