Re: function for testing that causes the backend to terminate

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: function for testing that causes the backend to terminate
Дата
Msg-id CADK3HHLMMrMMB=8gCxQHM7d2DWs8grigc+7UtsCPDvT+qpR7SA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: function for testing that causes the backend to terminate  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
Joe,

Thanks,

This works and I don't have to install anything!

Dave Cramer


On Thu, 29 Apr 2021 at 16:16, Joe Conway <mail@joeconway.com> wrote:
On 4/29/21 6:56 AM, Dave Cramer wrote:
> For testing unusual situations I'd like to be able to cause a backend to
> terminate due to something like a segfault. Do we currently have this in
> testing ?

If you can run SQL as a superuser from that backend, try:

COPY (SELECT pg_backend_pid())
  TO PROGRAM 'xargs kill -SIGSEGV';

HTH,

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

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

Предыдущее
От: Chapman Flack
Дата:
Сообщение: Re: Granting control of SUSET gucs to non-superusers
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: MaxOffsetNumber for Table AMs