DescriptionJason DeTiberus
2014-10-14 18:19:47 UTC
+++ This bug was initially created as a clone of Bug #1150736 +++
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.
--- Additional comment from Michal Fojtik on 2014-10-09 08:23:04 EDT ---
John, thanks for reporting this. I created a PR to add timestamp into postgresql logs:
https://github.com/openshift/origin-server/pull/5862
--- Additional comment from openshift-github-bot on 2014-10-09 15:48:27 EDT ---
Commit pushed to master at https://github.com/openshift/origin-serverhttps://github.com/openshift/origin-server/commit/4b1a464a0e748693f5168ecf37296059092b7e72Bug 1150736 - Add timestamp to postgresql logs
--- Additional comment from John M on 2014-10-09 17:19:59 EDT ---
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.
--- Additional comment from Wenjing Zheng on 2014-10-09 22:50:54 EDT ---
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.
Verified on ose 2.2/2014-10-15.1.
Steps to verify:
1.Create app with postgresql-9.2
#rhc app create ruby1 ruby-1.9 postgresql-9.2
2.Check the db log.
#rhc tail ruby1
Actual results:
2.Have date and time info in db log:
#rhc tail ruby1
==> app-root/logs/postgresql.log <==
2014-10-16 07:25:01 GMT LOG: database system was shut down at 2013-05-21 05:07:11 GMT
2014-10-16 07:25:01 GMT LOG: database system is ready to accept connections
2014-10-16 07:25:01 GMT LOG: autovacuum launcher started
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.
https://rhn.redhat.com/errata/RHSA-2014-1796.html