Re: Finding deadlocks on postgresql ?

* Machiel Richards <machielr(at)rdc(dot)co(dot)za> [2010-08-13 11:36:47 +0200] wrote :

> Hi All
>
> I am trying to find out the following and google doesn't seem to
> be very helpful today :-(
>
> As part of creating a Daily health check for some postgresql
> databases, I am trying to determine whether the database have any
> deadlocks.
>
> I am not sure however how to do this and thus I am hoping
> someone can assist me here.
>
>
> Is there a method to check postgresql for any deadlocks via a
> query or perhaps other methods?
>
> I would really appreciate the help here.
>
> Regards
> Machiel

Hi,

Is there a thing I found in the archives :

http://archives.postgresql.org/pgsql-admin/2006-08/msg00248.php

Regards,
--
.''`. Edi Stojicevic
: :' : Debian GNU/Linux user, admin & developer - http://www.debian.org
`. `~'
`-
AUTHOR
FvwmAuto just appeared one day, nobody knows how.
-- FvwmAuto(1x)