| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | abbas alizadeh <ramkly(at)yahoo(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Kill postgresql process |
| Date: | 2021-06-14 15:49:08 |
| Message-ID: | CAOBaU_ZWKKOX8za8r_iOYwMz5w+G84z31jyOMVzu0SCaLWie2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Jun 14, 2021 at 11:41 PM abbas alizadeh <ramkly(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-06-14 16:15:35 | Re: Kill postgresql process |
| Previous Message | abbas alizadeh | 2021-06-14 15:41:02 | Kill postgresql process |