Re: Server-side killing of database connection (7.3.4)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Server-side killing of database connection (7.3.4)
Дата
Msg-id 5631.1076823279@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Server-side killing of database connection (7.3.4)  (Rune Froysa <rune.froysa@usit.uio.no>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: forcing SSL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Urgent!!!! Setting permissions on Views