"Niclas Gustafsson" <niclas.gustafsson@codesense.com> writes:
> Yes, I know that, I would like to know what commands the client
> has issued sofar in the transaction as this would help us to
> track down if there is some problems in the client, and which
> client that is stalling ( As we have a bunch of different clients
> Working towards the database).
Turn on debug_print_query, log_pid, log_timestamp, and perhaps
log_connections in postgresql.conf. The postmaster log will then
provide a pretty effective trace of what's going on.
BTW, in 7.2 you need to SIGHUP the postmaster after changing
postgresql.conf. I forget whether 7.1 expected that or not.
regards, tom lane