Postgres Pro
Downloads
Home   >   mailing lists

Re: Kill postgresql process - Mailing list pgsql-admin

From Julien Rouhaud
Subject Re: Kill postgresql process
Date
Msg-id CAOBaU_bSNffGTF8s8mis28DDUOT1e2xC2cEhdHxEGLj5wAg=_w@mail.gmail.com
Whole thread Raw
In response to Re: Kill postgresql process  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Kill postgresql process
List pgsql-admin
Tree view
Le mar. 15 juin 2021 à 00:15, Laurenz Albe:

- Attach to the backend with gdb.
- Enter "print ProcessInterrupts()"

Of course that will not work if the backend is in uninterruptible
sleep (for example, stuck in an I/O operation).

that may be a terrible idea and leave a buffer pinned or something. and if it's not it won't tell us where we're missing a CALL_FOR_INTERRUPTS

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Kill postgresql process
Next
From: abbas alizadeh
Date:
Subject: Re: Kill postgresql process