| 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 17:03:16 |
| Message-ID: | 20210614170316.vczahkopebqrkyxy@nol |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vineet Naik | 2021-06-15 06:10:48 | Re: Autovacuum or manual vacuum to recover from XID wraparound? |
| Previous Message | Wells Oliver | 2021-06-14 16:50:48 | pg_restore, custom setting, and materialized view -- performance question |