Re: Kill postgresql process - Mailing list pgsql-admin

From Julien Rouhaud
Subject Re: Kill postgresql process
Date
Msg-id 20210614170316.vczahkopebqrkyxy@nol
Whole thread Raw
In response to Re: Kill postgresql process  (abbas alizadeh <ramkly@yahoo.com>)
List pgsql-admin
On Tue, Jun 15, 2021 at 12:32:40AM +0800, abbas alizadeh wrote:
> 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.

Yes, I understand that.  What do you see in pg_stat_activity for the given pid?

Is there any chance you can get a stack trace (with the link previously
provided)?

>  Postgres version is 9.2 for this case.

Which minor version?



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: pg_restore, custom setting, and materialized view -- performance question
Next
From: Vineet Naik
Date:
Subject: Re: Autovacuum or manual vacuum to recover from XID wraparound?