Re: Database in use? - Mailing list pgsql-admin

From Lukas
Subject Re: Database in use?
Date
Msg-id 50659.217.117.29.29.1236026123.squirrel@fmf.vgtu.lt
Whole thread Raw
In response to Database in use?  (Carol Walter <walterc@indiana.edu>)
Responses Re: Database in use?
List pgsql-admin
Hi,

 try this:
SELECT * FROM pg_stat_activity;

Maybe it will show you who is using it..


--
Lukas
UAB nSoft
http://www.nsoft.lt
Lukas at nsoft.lt
+370 655 10 655


> Periodically, my databases will give me a message that says that
> someone is using the database when it appears that no one is.  What
> causes this?  What can I do about it?
>
> Thanks,
> Carol
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>



--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database in use?
Next
From: Julio Leyva
Date:
Subject: Re: Database in use?