X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 596739FA646 for ; Sun, 25 Jun 2006 23:05:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 02878-09 for ; Sun, 25 Jun 2006 23:05:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from grp-smtp.toray.com.my (grp-smtp.toray.com.my [202.186.44.7]) by postgresql.org (Postfix) with ESMTP id 9BA409FA5FE for ; Sun, 25 Jun 2006 23:05:07 -0300 (ADT) Received: from localhost (localhost.toray.com.my [127.0.0.1]) by grp-smtp.toray.com.my (Postfix) with ESMTP id 4584650911; Mon, 26 Jun 2006 10:04:56 +0800 (MYT) X-Virus-Scanned: amavisd-new at toray.com.my Received: from grp-smtp.toray.com.my ([127.0.0.1]) by localhost (grp-smtp.pengroup.com.my [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id SE6mXAaYglUW; Mon, 26 Jun 2006 10:04:54 +0800 (MYT) Received: from notes01.pengroup.com.my (notes01.toray.com.my [10.200.1.1]) by grp-smtp.toray.com.my (Postfix) with ESMTP id 396DD5092B; Mon, 26 Jun 2006 10:04:52 +0800 (MYT) Subject: Re: Is it possible to trace all transactions done? To: "hubert depesz lubaczewski" Cc: pgsql-admin@postgresql.org X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: kah_hang_ang@toray.com.my Date: Mon, 26 Jun 2006 10:04:52 +0800 X-MIMETrack: Serialize by Router on Notes01/Pen-Group(Release 6.5.1|January 21, 2004) at 06/26/2006 10:04:52 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/220 X-Sequence-Number: 22182 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@toray.com.my" Subject: Re: [ADMIN] Is it possible to trace all transactions done? 06/24/2006 05:25 PM On 6/23/06, kah_hang_ang@toray.com.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