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

migrated from stackoverflow.com 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? 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
1  
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

 
discard

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

Browse other questions tagged or ask your own question.