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:       "[EMAIL PROTECTED]" 
<[EMAIL PROTECTED]>                       
                      <[EMAIL PROTECTED]        cc:       
pgsql-admin@postgresql.org                                                    
                      >                        Subject:  Re: [ADMIN] Is it 
possible to trace all transactions done?                    
                                                                                
                                                       
                      06/24/2006 05:25                                          
                                                       
                      PM                                                        
                                                       
                                                                                
                                                       
                                                                                
                                                       




On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to