Description of problem: Date / Time not in postgresql.log file in /log folder Version-Release number of selected component (if applicable): 9.x How reproducible: Add postgres, start it up, you won't have date / time in log file. Steps to Reproduce: 1. Created Postgres SQL 9.x cartridge 2. Start DB 3. Check log file. Actual results: No dates on log lines Expected results: Date / Time on each line Additional info: I don't mind having to modify the .CONF file for postgres, but people are saying not to do that.
John, thanks for reporting this. I created a PR to add timestamp into postgresql logs: https://github.com/openshift/origin-server/pull/5862
Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/4b1a464a0e748693f5168ecf37296059092b7e72 Bug 1150736 - Add timestamp to postgresql logs
Michal, You guys totally rock! this will really help me. Ultimately, is there a way to modify the .conf file by hand just in case? Or does it get generated each time Postgresql is started? Thanks again for such a quick turnaround.
Verified on devenv_5222, the date/time displays in postgresql.log: [wzheng@rh6-openshift apps]$ rhc tail php ==> app-root/logs/postgresql.log <== 2014-10-10 06:36:03 GMT LOG: could not bind socket for statistics collector: Permission denied 2014-10-10 06:36:03 GMT LOG: disabling statistics collector for lack of working socket 2014-10-10 06:36:03 GMT WARNING: autovacuum not started because of misconfiguration 2014-10-10 06:36:03 GMT HINT: Enable the "track_counts" option. 2014-10-10 06:36:03 GMT LOG: database system was shut down at 2013-05-21 05:07:11 GMT 2014-10-10 06:36:03 GMT LOG: database system is ready to accept connections If there will be more fix based on John's comments, I will verify again. For now, mark this bug verified as it has made data/time displayed in postgresql.log.