Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How to create/update log file for each modifications(insert,update,delete) in my database. i cant find any feasible methods to achieve so. can anybody know how to implement this.? if so then please provide some examples for the same.

share|improve this question

migrated from Mar 20 '13 at 10:22

This question came from our site for professional and enthusiast programmers.

Can you explain what you want that is different from log_statement?… –  Richard Huxton Mar 19 '13 at 12:11
@RichardHuxton i had managed to set the value of log-statement to mod in postgresql.conf. but i am not sure that whether my transactions are logging or not.? if it is logging then how can i open or view the logged data.? –  GLOIER TECH. Mar 19 '13 at 12:25
Umm - look in the log file? –  Richard Huxton Mar 19 '13 at 12:25
@RichardHuxton possibly i searched all the directories inside my postgresql folder inside program files, but no luck.! where is that file actually.? and shall i believe, changing the value to mod will surely log my data.? –  GLOIER TECH. Mar 19 '13 at 12:29
What gets logged and where it gets logged to is all down to your configuration. Check your configuration, then check your log-file. –  Richard Huxton Mar 19 '13 at 12:31

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.