Re: Server-side killing of database connection (7.3.4) - Mailing list pgsql-admin

From Tom Lane
Subject Re: Server-side killing of database connection (7.3.4)
Date
Msg-id 5631.1076823279@sss.pgh.pa.us
Whole thread Raw
In response to Server-side killing of database connection (7.3.4)  (Rune Froysa <rune.froysa@usit.uio.no>)
List pgsql-admin
Rune Froysa <rune.froysa@usit.uio.no> writes:
> I need to kill a connected database user.  I'm able to find the pid
> associated with the troublesome user.  However, if I try killing the
> process with any of INT, TERM or QUIT, all connected database users
> get the message:

>    WARNING:  Message from PostgreSQL backend:
>            The Postmaster has informed me that some other backend
>            died abnormally and possibly corrupted shared memory.
>            I have rolled back the current transaction and am
>            going to terminate your database system connection and exit.
>            Please reconnect to the database system and repeat your query.

Better take another look at how you're doing that kill.  It is not
sending the signal number you think it is.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: forcing SSL
Next
From: Tom Lane
Date:
Subject: Re: Urgent!!!! Setting permissions on Views