Re: Database in use?

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(at)postgresql(dot)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.