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 6794F9F9FE3 for ; Sat, 24 Jun 2006 06:25:31 -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 20852-05 for ; Sat, 24 Jun 2006 06:25:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.234]) by postgresql.org (Postfix) with ESMTP id 2F3E29F9AD3 for ; Sat, 24 Jun 2006 06:25:27 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so787582wra for ; Sat, 24 Jun 2006 02:25:26 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=pAxz3FqFGYzKcmcE87wshsUJqsCbetRmsULLHeWCKACCB8js0Rd5qw1TlAnyM5+00OsYVQs5S6PTuJBQrJtkEvbSJm995aZ/x8WasV3kx3+AG0/99Ec2MI5Vw5FjhxHnG60sCfHJBeL+i/ulr9afCfOJNOuudQndBwBz+0m8UiU= Received: by 10.64.148.4 with SMTP id v4mr1000037qbd; Sat, 24 Jun 2006 02:25:26 -0700 (PDT) Received: by 10.65.75.17 with HTTP; Sat, 24 Jun 2006 02:25:25 -0700 (PDT) Message-ID: <9e4684ce0606240225k192ca337v9cead975af5bd928@mail.gmail.com> Date: Sat, 24 Jun 2006 11:25:25 +0200 From: "hubert depesz lubaczewski" To: "kah_hang_ang@toray.com.my" Subject: Re: Is it possible to trace all transactions done? Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19247_30426211.1151141125962" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/217 X-Sequence-Number: 22179 ------=_Part_19247_30426211.1151141125962 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_19247_30426211.1151141125962 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 6/23/06, kah_hang_ang@toray.com.my <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 ------=_Part_19247_30426211.1151141125962--