Re: Is it possible to trace all transactions done?

Depesz,

Thanks, this is I what I need.
After I enable the log_statement Postgresql do log the statements triggered
but I need more detail info. - time the statements been triggered to be log
as well,
is it any way to do that?

Regards,
KH Ang

"hubert depesz
lubaczewski" To: "kah_hang_ang(at)toray(dot)com(dot)my" <kah_hang_ang(at)toray(dot)com(dot)my>
<depesz(at)gmail(dot)com cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Is it possible to trace all transactions done?

06/24/2006 05:25
PM

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