Re: Handling idle connections

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Handling idle connections
Дата
Msg-id CAMkU=1xiG4S+gxLMfE-F6vSjchoBwfnZd4W8KdOSO7DMt2zDSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Handling idle connections  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Ответы Re: Handling idle connections
Список pgsql-admin
Дерево обсуждения
On Mon, Sep 25, 2023 at 12:27 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Yes, i came here only after doing a lot of research on internet. I am doing most of these things already. 

I need help on two things now.

1. I see lot of idle connections where application_name is blank and also query is blank, i am identifying only with user. In this case how do I identify which application is using idle connection?

Are you querying pg_stat_activity as a superuser, or at least a user who is a member of pg_monitor?  If not, many fields will be uninformative due to security reasons.  Although "query" shouldn't be literally blank, it should be the string '<insufficient privilege>', but maybe you misinterpreted that as being blank and being filled-in client-side.

If you are querying it as the superuser and still don't know who is connecting to your database, maybe it is time to change the password and be more diligent about who you hand it out to.

Cheers,

Jeff

В списке pgsql-admin по дате отправления:

Предыдущее
От: Marcus Vinicius Castro
Дата:
Сообщение: Re: Seed pgAdmin roles with Active Directory groups when using Docker
Следующее
От: Zhaoxun Yan
Дата:
Сообщение: pg_rewind: ERROR: could not fetch remote file "global/pg_control": ERROR: permission denied