Обсуждение: Postgres Table level statement logging

On Feb 7, 2012, at 5:42 AM, Madhu S R wrote:

> I need to log the statements executed for a list of tables. It will be Data Modification statements like
INSERT/UPDATE/DELETEon any of these tables. Please let me know if this is possible in postgres logging. 

Yes, this possible. You can set log_statement parameter.
http://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-LOG-STATEMENT


Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com

Madhu S R <s_r_madhu@yahoo.co.in> wrote:

> Hi,
>
> I need to log the statements executed for a list of tables. It will be Data
> Modification statements like INSERT/UPDATE/DELETE on any of these tables.
> Please let me know if this is possible in postgres logging.

http://andreas.scherbaum.la/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°