pginfo wrote:
> Hi,
> I can not be sure if it is not the case.
> But we are usin this system on a number of servers and it happen only by
> one.
> Can I with a pg_locks help detect the query that is running?
No the pg_locks detect only which process handle a lock on a
database object.
With pg_stat_activity you see the queries running.
Also the command
ps -eafwww | grep post
show you the connection and his state, I bet
you have some connection "IDLE in TRANSACTION"
Regards
Gaeatano Mendola