From: | kah_hang_ang(at)toray(dot)com(dot)my |
---|---|
To: | "hubert depesz lubaczewski" <depesz(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Is it possible to trace all transactions done? |
Date: | 2006-06-26 02:04:52 |
Message-ID: | OF1DA0FDDC.2B0B5202-ON48257199.000365F2@pengroup.com.my |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-06-26 02:24:15 | Re: Is it possible to trace all transactions done? |
Previous Message | Dawid Kuroczko | 2006-06-25 12:01:47 | Re: 8.x Vaccum/Autovacuum settings |