how to log trigger intiated CRUD queries on postgresql 8.4

Posted by user47650 on Server Fault See other posts from Server Fault or by user47650
Published on 2011-06-29T16:19:32Z Indexed on 2011/06/29 16:23 UTC
Read the original article Hit count: 311

Filed under:

in the postgresql config file there is an option

log_statement = 'mod'

which causes CRUD statements to be logged.

However this does not include the CRUD statements that are called from trigger functions, which means that following the log file is not useful to determine what changes are being made to the database data, if the 3rd part application has been making lots of changes using triggers.

Is there some other option I can use to include trigger CRUD?

alternatively, can I inspect the pg_xlog in real time using some tool?

(xlogdump and xlogviewer do not work with version 8.4, i have tried)

© Server Fault or respective owner

Related posts about postgresql