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
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 ?
- 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
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