Re: function for testing that causes the backend to terminate - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: function for testing that causes the backend to terminate
Date
Msg-id CADK3HHLMMrMMB=8gCxQHM7d2DWs8grigc+7UtsCPDvT+qpR7SA@mail.gmail.com
Whole thread Raw
In response to Re: function for testing that causes the backend to terminate  (Joe Conway <mail@joeconway.com>)
List 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 by date:

Previous
From: Chapman Flack
Date:
Subject: Re: Granting control of SUSET gucs to non-superusers
Next
From: Jeff Davis
Date:
Subject: Re: MaxOffsetNumber for Table AMs