Re: [ADMIN] Disconnecting non active (IDLE ) users

2007-02-28 Thread Ezequias Rodrigues da Rocha
I would like to know how postgresql defines that a connection is inactive. I have the same problem but in the future I couldn't restart my server every day. Any explanation ? Ezequias 2007/2/26, Goran Rakic [EMAIL PROTECTED]: I have installed POSTGRESQL 8.2 on W2K3 32bit , 100 users connecting

Re: [ADMIN] Disconnecting non active (IDLE ) users

2007-02-28 Thread Shane Ambler
Ezequias Rodrigues da Rocha wrote: I would like to know how postgresql defines that a connection is inactive. I have the same problem but in the future I couldn't restart my server every day. I believe IDLE = not currently processing a query / sending data back to client. Any explanation ?

Re: [Bulk] Re: [ADMIN] Disconnecting non active (IDLE ) users

2007-02-28 Thread Ted Byers
- Original Message - From: Ezequias Rodrigues da Rocha [EMAIL PROTECTED] To: Goran Rakic [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Wednesday, February 28, 2007 11:01 AM Subject: [Bulk] Re: [ADMIN] Disconnecting non active (IDLE ) users I would like to know how

[ADMIN] Disconnecting non active (IDLE ) users

2007-02-26 Thread Goran Rakic
I have installed POSTGRESQL 8.2 on W2K3 32bit , 100 users connecting from desktop applications and 200 users connecting thru web service from handheld computers I have problem with second groups of users. Often they do not disconnect from POSTGRE Server and with time passing thru I have lot