Re: Kill postgresql process

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Kill postgresql process
Дата
Msg-id 20210614170316.vczahkopebqrkyxy@nol
обсуждение исходный текст
Ответ на Re: Kill postgresql process  (abbas alizadeh <ramkly@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: pg_restore, custom setting, and materialized view -- performance question
Следующее
От: Vineet Naik
Дата:
Сообщение: Re: Autovacuum or manual vacuum to recover from XID wraparound?