Take the 2-minute tour ×
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
Can you explain what you want that is different from log_statement? postgresql.org/docs/current/static/… –  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
show 2 more comments

migrated from stackoverflow.com Mar 20 '13 at 10:22

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

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.