Обсуждение: Is it possible to trace all transactions done?

Поиск
Список
Период
Сортировка

Is it possible to trace all transactions done?

От
kah_hang_ang@toray.com.my
Дата:



Hi,

Is Postgresql provide feature to log all the transactions/queries have been
triggered into log?

Thanks.


Re: Is it possible to trace all transactions done?

От
"hubert depesz lubaczewski"
Дата:
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

Re: Is it possible to trace all transactions done?

От
kah_hang_ang@toray.com.my
Дата:



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" <kah_hang_ang@toray.com.my>
               
                      <depesz@gmail.com        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, 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



Re: Is it possible to trace all transactions done?

От
Tom Lane
Дата:
kah_hang_ang@toray.com.my writes:
> 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,

In recent PG releases you set log_line_prefix to add whatever you want
to log entries.  Older versions are a bit less flexible, but there's
pretty much always been an option to include a timestamp in log entries.
Please read the administrator's guide ...

            regards, tom lane