Difference between terminate/cancel?

Поиск
Список
Период
Сортировка
От François Beausoleil
Тема Difference between terminate/cancel?
Дата
Msg-id 6DFB1A68-074D-42B9-8DCF-53DE1C0E8C5E@teksol.info
обсуждение исходный текст
Ответы Re: Difference between terminate/cancel?  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-general
Hi!

What is the difference between both? cancel sends QUIT while terminate sends TERM, but what effect does this have on the backends, shared memory, etc?

I had some processes stuck in IDLE in transaction after a machine died (through pgbouncer), and cancel did not close the connections, while terminate did kill the transactions.

The docs at http://www.postgresql.org/docs/9.1/static/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE do name the signals, but I can't find other documentation on the effects of TERM/QUIT (I'm on 9.1, but devel says the same thing).

Are there pointers in the docs on the differences?

Thanks!
François
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Brian Hirt
Дата:
Сообщение: View permission error after upgrading from 8.4 -> 9.2
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Difference between terminate/cancel?