You might locate the process id with ps.... If someone has a connection on
the DB -- It'll show the IP address of the user and a pid...
--> ps ax | grep postgres
"Garo Hussenjian" <garo@xapnet.com> wrote in message
news:BA5D5658.6E5D%garo@xapnet.com...
> I'm trying to track down a query in a web application that has postgresql
in
> a deadlock. I don't know which query is running because I only see the
> listing in ps aux (for now, anyway)... Is there any way to view the query
> that is being run from knowing a process id?
>
> Garo.
>
> =-=-==-=-=-==
>
> Xapnet Internet Solutions
> 1501 Powell St., Suite N
> Emeryville, CA 94608
>
> Tel - (510) 655-9771
> Fax - (510) 655-9775
> Web - http://www.xapnet.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster