The query was called by web server, It was connected to database through socket and connection wasn’t terminate. I tried to close the connection, but it didn’t work. Postgres version is 9.2 for this case. We use postgis and pg_repack > On 14 Jun 2021, at 11:49 PM, Julien Rouhaud <rjuju123@xxxxxxxxx> wrote: > > On Mon, Jun 14, 2021 at 11:41 PM abbas alizadeh <ramkly@xxxxxxxxx> 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 > >
