Re: function for testing that causes the backend to terminate

2021-05-03 Thread Dave Cramer
Joe, Thanks, This works and I don't have to install anything! Dave Cramer On Thu, 29 Apr 2021 at 16:16, Joe Conway 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

Re: function for testing that causes the backend to terminate

2021-05-01 Thread Andrew Dunstan
On 4/29/21 4:16 PM, Joe Conway 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

Re: function for testing that causes the backend to terminate

2021-04-30 Thread Bharath Rupireddy
On Thu, Apr 29, 2021 at 4:36 PM Bharath Rupireddy wrote: > > On Thu, Apr 29, 2021 at 4:27 PM 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 ? > > Well, you

Re: function for testing that causes the backend to terminate

2021-04-29 Thread Joe Conway
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

Re: function for testing that causes the backend to terminate

2021-04-29 Thread Bharath Rupireddy
On Thu, Apr 29, 2021 at 4:27 PM 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 ? Well, you could use pg_terminate_backend which sends SIGTERM to the backend.

function for testing that causes the backend to terminate

2021-04-29 Thread Dave Cramer
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 ? Dave Cramer