Thx a lot Nicolas,
I finaly success to log query statement because of your simple explanation.
I have other question:
1. Is there posibility to automatically logging that statement to table?
2. All of that statement is come from every database on my server,
could I know from which database that statement come?
or at least I can filter to log only from database X ?
3. If I need to log only changed made on my database, then the value of
'log_statement' is 'mod' ?
CMIIW
Regards,
Joko [SYSTEM]
PT. Indra Jaya Swastika
Phone: +62 31 7481388 Ext 201
http://www.ijs.co.id
--sorry for my bad english
----- Original Message -----
From: "Pomarede Nicolas" <npomarede@xxxxxxxxxxxx>
To: "System/IJS - Joko" <system@xxxxxxxxx>
Cc: <pgsql-performance@xxxxxxxxxxxxxx>
Sent: Friday, July 18, 2008 3:16 PM
Subject: Re: [PERFORM] log_statement at postgres.conf
There're 2 points in your question :
- what to log
- where to log
To choose 'what' to log in your case, you can change 'log_statement' to
'all'.
Then, to choose 'where' to log, you can either use the proposal in the
first answer, or change 'log_destination' to 'stderr' and
'redirect_stderr' to 'on'.
Nicolas
--
If you have any problem with our services ,
please contact us at 70468146 or e-mail: helpdesk@xxxxxxxxx
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388
