On Mon, Jun 14, 2021 at 11:41 PM abbas alizadeh <ramkly@yahoo.com> wrote:
>
> How we can kill the stuck process?
> The process didn’t kill by pg_cancel_backend/pg_terminate_backend.
> Is there any way beside of using “kill -9” or “pg_ctl kill ABRT” ?
pg_cancel_backend / pg_terminate_backend is the normal way to do that.
If it's not working it means there's something going on. Is it a
regular backend, and if yes what query is it executing?
Do you have any 3rd party extensions, and what is the postgres versions?
If could also help to get a stack trace:
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend