Message-ID: <48F00111.7070801@ijs.co.id>
Date: Sat, 11 Oct 2008 08:27:45 +0700
From: IJS/System - Joko <system@ijs.co.id>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: logging SQL statements
References: <d8e7a1e30810090623i7766fc50xb46fc3e5efa3836@mail.gmail.com>
	<08312950-67ba-43ad-9d6d-2c2e1b227274@o40g2000prn.googlegroups.com>
In-Reply-To: 
 <08312950-67ba-43ad-9d6d-2c2e1b227274@o40g2000prn.googlegroups.com>
Content-Type: multipart/alternative;
	boundary="------------010702040800030802070601"

This is a multi-part message in MIME format.
--------------010702040800030802070601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

It's surely possible.

Just enable this at postgresql.conf:
log_destination = 'stderr'
redirect_stderr = on

And then choose what to log:
log_statement = 'all'

Valid values are none, ddl, mod, and all. ddl logs all data definition 
commands like CREATE, ALTER, and DROP commands. mod logs all ddl 
statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. 
PREPARE and EXPLAIN ANALYZE statements are also logged if their 
contained command is of an appropriate type.

And u can modify other variables as you want.

Regards,
Joko [IT/EDP]
PT. Indra Jaya Swastika
Phone: +62 31 7481388  Ext 201
http://www.ijs.co.id


Jagadeesh wrote:
> On Oct 9, 6:23 pm, shreeseva.learn...@gmail.com ("c k") wrote:
>   
>> Is it possible to log all sql statements submitted to database server in a
>> table in that database it self? This will be different from database logs
>> which are written by db server.
>> Regards,
>> CPK
>>     
>
> I am not confident but it should be posible. some settings like debug
> would log every thing in a logfile.
> Will check more on this and update.
> Thanks
>
>   


--
If you have any problem with our services ,
please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388

--------------010702040800030802070601
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Verdana">It's surely possible.<br>
<br>
Just enable this at postgresql.conf:<br>
log_destination = 'stderr'<br>
redirect_stderr = on<br>
<br>
And then choose what to log:<br>
log_statement = 'all' <br>
<br>
Valid values are none, ddl, mod, and all. ddl logs all data definition
commands like CREATE, ALTER, and DROP commands. mod logs all ddl
statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM.
PREPARE and EXPLAIN ANALYZE statements are also logged if their
contained command is of an appropriate type. <br>
<br>
And u can modify other variables as you want.<br>
</font></font>
<pre class="moz-signature" cols="72">Regards,
Joko [IT/EDP]
PT. Indra Jaya Swastika
Phone: +62 31 7481388  Ext 201
<a class="moz-txt-link-freetext" href="http://www.ijs.co.id">http://www.ijs.co.id</a></pre>
<br>
<br>
Jagadeesh wrote:
<blockquote
 cite="mid:08312950-67ba-43ad-9d6d-2c2e1b227274@o40g2000prn.googlegroups.com"
 type="cite">
  <pre wrap="">On Oct 9, 6:23 pm, <a class="moz-txt-link-abbreviated" href="mailto:shreeseva.learn...@gmail.com">shreeseva.learn...@gmail.com</a> ("c k") wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Is it possible to log all sql statements submitted to database server in a
table in that database it self? This will be different from database logs
which are written by db server.
Regards,
CPK
    </pre>
  </blockquote>
  <pre wrap=""><!---->
I am not confident but it should be posible. some settings like debug
would log every thing in a logfile.
Will check more on this and update.
Thanks

  </pre>
</blockquote>
</body>
</html>


<html>
<br>
--<br>
If you have any problem with our services ,<br>
please contact us at 70468146 or e-mail: helpdesk@ijs.co.id<br>
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388</html>

--------------010702040800030802070601--