logging - Postgresql 9.3 log only insert, delete and update -



logging - Postgresql 9.3 log only insert, delete and update -

i want log queries modify tables (insert, delete, update) while ignoring selects , equivalents.

however, in documentation, options log ddl, ddl+mod or in log_statement line of postgresql.conf file.

is there way log files queries manipulate info changing settings of configuration file or have utilize outside script or log tables?

my current settings on postgresql.conf, still logs select queries, follow:

log_destination = 'syslog, csvlog' logging_collector = on log_min_duration_statement = 0 log_statement = mod

as a_horse_with_no_name , craig pointed out, log_statement = mod shouldn't logging select statements.

my problem log_min_duration_statement = 0, acting and, (log , that). i've commented log_min_duration out , logging needed.

postgresql logging

Comments

Popular posts from this blog

php - Edges appear in image after resizing -

ios8 - iOS custom keyboard - preserve state between appearances -

Delphi change the assembly code of a running process -