Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: abbas alizadeh <ramkly@yahoo.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Kill postgresql process
Date: Tue, 15 Jun 2021 00:32:40 +0800
Message-Id: <C26A3E91-96C6-41A7-BD6E-3FF203BDFC5D@yahoo.com>
References: 
 <CAOBaU_ZWKKOX8za8r_iOYwMz5w+G84z31jyOMVzu0SCaLWie2Q@mail.gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
In-Reply-To: 
 <CAOBaU_ZWKKOX8za8r_iOYwMz5w+G84z31jyOMVzu0SCaLWie2Q@mail.gmail.com>
To: Julien Rouhaud <rjuju123@gmail.com>
Content-Length: 1080
Archived-At: 
 <https://www.postgresql.org/message-id/C26A3E91-96C6-41A7-BD6E-3FF203BDFC5D%40yahoo.com>
Precedence: bulk

The query was called by web server, It was connected to database through soc=
ket and connection wasn=E2=80=99t terminate. I tried to close the connection=
, but it didn=E2=80=99t 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@gmail.com> wrote:
>=20
> =EF=BB=BFOn Mon, Jun 14, 2021 at 11:41 PM abbas alizadeh <ramkly@yahoo.com=
> wrote:
>>=20
>> How we can kill the stuck process?
>> The process didn=E2=80=99t kill by pg_cancel_backend/pg_terminate_backend=
.
>> Is there any way beside of using =E2=80=9Ckill -9=E2=80=9D or =E2=80=9Cpg=
_ctl kill ABRT=E2=80=9D ?
>=20
> 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?
>=20
> Do you have any 3rd party extensions, and what is the postgres versions?
>=20
> If could also help to get a stack trace:
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_=
backend
>=20
>=20