[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Dropped User Session
From:       Vishal Kohli <vishal.kohli75 () gmail ! com>
Date:       2018-11-30 11:50:57
Message-ID: CAGx4VSVjeD1Q8Q2zMJnknzm7zwCwU99gCWJC_1TJJRj08pP_Xw () mail ! gmail ! com
[Download RAW message or body]

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
>
>
>

[Attachment #3 (text/html)]

<div><div dir="auto">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.</div></div><div><br><div class="gmail_quote"><div \
dir="ltr">On Fri, 30 Nov 2018 at 5:08 PM, Vishal Kohli &lt;<a \
href="mailto:vishal.kohli75@gmail.com">vishal.kohli75@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div \
dir="ltr"><div>Hello,</div><div><br></div><div>Is there a view in database to find \
sessions PID of dropped user in \
database?</div><div><br></div><div>Thanks,</div><div>Vishal<br></div><div><br></div><div><br></div></div>
 </blockquote></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]