Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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


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

Browse other questions tagged or ask your own question.