Postgres Pro
Downloads
Home   >   mailing lists

Re: Dropped User Session - Mailing list pgsql-admin

From Vishal Kohli
Subject Re: Dropped User Session
Date
Msg-id CAGx4VSVjeD1Q8Q2zMJnknzm7zwCwU99gCWJC_1TJJRj08pP_Xw@mail.gmail.com
Whole thread Raw
In response to Dropped User Session  (Vishal Kohli <vishal.kohli75@gmail.com>)
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Vishal Kohli
Date:
Subject: Dropped User Session
Next
From: Stephen Frost
Date:
Subject: Re: Backup solution over unreliable network