Re: Is it possible to trace all transactions done?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kah_hang_ang(at)toray(dot)com(dot)my
Cc: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Is it possible to trace all transactions done?
Date: 2006-06-26 02:24:15
Message-ID: 17963.1151288655@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

kah_hang_ang(at)toray(dot)com(dot)my writes:
> 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,

In recent PG releases you set log_line_prefix to add whatever you want
to log entries. Older versions are a bit less flexible, but there's
pretty much always been an option to include a timestamp in log entries.
Please read the administrator's guide ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sidar López Cruz 2006-06-26 02:28:59 TSearch2
Previous Message kah_hang_ang 2006-06-26 02:04:52 Re: Is it possible to trace all transactions done?