Re: PG_XLOG grows and grows

"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