Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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)

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.