ps -ef | grep postgres
> Date: Mon, 2 Mar 2009 22:35:23 +0200 > Subject: Re: [ADMIN] Database in use? > From: lu...@fmf.vtu.lt > To: pgsql-admin@postgresql.org > > 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. > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin
