FAQ
Hi list,

Is there a possibility for a dbA to immediately terminate a working user
connection?

JY
--

Search Discussions

  • Mark at Jun 29, 2011 at 1:40 am

    -----Original Message-----
    From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-
    owner@postgresql.org] On Behalf Of Jean-Yves F. Barbier
    Sent: Tuesday, June 28, 2011 12:16 PM
    To: pgsql-novice@postgresql.org
    Subject: [NOVICE] terminate a coonextion within pg

    Hi list,

    Is there a possibility for a dbA to immediately terminate a working
    user
    connection?

    JY
    SELECT pg_termindate_backend(process_id);

    --


    --
    Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-novice
  • Jean-Yves F. Barbier at Jun 29, 2011 at 2:01 am

    On Tue, 28 Jun 2011 19:39:57 -0600, "mark" wrote:

    Is there a possibility for a dbA to immediately terminate a working
    user
    connection?

    JY
    SELECT pg_termindate_backend(process_id);
    Perfect, thanks.

    --
  • Lew at Jun 29, 2011 at 5:07 am

    Jean-Yves F. Barbier wrote:
    "mark"wrote:
    Jean-Yves F. Barbier wrote:
    Is there a possibility for a dbA to immediately terminate a working
    user connection?
    SELECT pg_termindate_backend(process_id);1
    Perfect, thanks.
    That should be "pg_terminate_backend(pid int)".

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJun 28, '11 at 6:16p
activeJun 29, '11 at 5:07a
posts4
users3
websitepostgresql.org
irc#postgresql

3 users in discussion

Jean-Yves F. Barbier: 2 posts Lew: 1 post Mark: 1 post

People

Translate

site design / logo © 2022 Grokbase