Re: Is it possible to trace all transactions done?

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: "kah_hang_ang(at)toray(dot)com(dot)my" <kah_hang_ang(at)toray(dot)com(dot)my>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Is it possible to trace all transactions done?
Date: 2006-06-24 09:25:25
Message-ID: 9e4684ce0606240225k192ca337v9cead975af5bd928@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 6/23/06, kah_hang_ang(at)toray(dot)com(dot)my <kah_hang_ang(at)toray(dot)com(dot)my> wrote:
>
> Is Postgresql provide feature to log all the transactions/queries have
> been
> triggered into log?
>

sure. check you postgresl.conf file.
log_statement is what you're looking for.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2006-06-24 22:03:39 8.x Vaccum/Autovacuum settings
Previous Message Jeff Frost 2006-06-23 22:31:54 Re: strange fsm issues