Обсуждение: Dropped User Session

Поиск
Список
Период
Сортировка

Dropped User Session

От
Vishal Kohli
Дата:
Hello,

Is there a view in database to find sessions PID of dropped user in database?

Thanks,
Vishal


Re: Dropped User Session

От
Vishal Kohli
Дата:
I dropped a connected user in database, cannot find pid in pg_stat_activity. I can query from dropped user session but how to find session in database without going into OS.

On Fri, 30 Nov 2018 at 5:08 PM, Vishal Kohli <vishal.kohli75@gmail.com> wrote:
Hello,

Is there a view in database to find sessions PID of dropped user in database?

Thanks,
Vishal


Re: Dropped User Session

От
Vishal Kohli
Дата:
I dropped a connected user in database, cannot find pid in pg_stat_activity. I can query from dropped user session but how to find session in database without going into OS.

On Fri, 30 Nov 2018 at 5:08 PM, Vishal Kohli <vishal.kohli75@gmail.com> wrote:
Hello,

Is there a view in database to find sessions PID of dropped user in database?

Thanks,
Vishal