Re: Killing Long running query or user session

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: David Ecker <david(at)familie-ecker(dot)net>
Subject: Re: Killing Long running query or user session
Date: 2004-08-10 14:27:54
Message-ID: 4118DB6A.2020802@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

David Ecker wrote:

> Is there a posibilty to kick the session through a sql-statement?

NOPE

> Another posibility would be to block access to a database for a set of
> users/groups using sql only. Is there such a command?

You can allow the acces to certain DB to a user and from some IP,
I don't know if this can help you and/or if solve your problem.

Regards
Gaetano Mendola

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bill Montgomery 2004-08-10 15:10:19 Re: Replication
Previous Message Rodrigo Botana 2004-08-10 13:39:41 Replication