Bug 1150736

Summary:	PostGresSQL Logging datetime
Product:	OpenShift Online	Reporter:	John M <john>
Component:	Image	Assignee:	Michal Fojtik <mfojtik>
Status:	CLOSED CURRENTRELEASE	QA Contact:	libra bugs <libra-bugs>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	2.x	CC:	jokerman, mmccomas, wzheng
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	1151575 1152698 (view as bug list)		Environment:
Last Closed:	2015-02-18 16:51:44 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1152698

Description John M 2014-10-08 20:31:46 UTC

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.

Comment 1 Michal Fojtik 2014-10-09 12:23:04 UTC

John, thanks for reporting this. I created a PR to add timestamp into postgresql logs:

https://github.com/openshift/origin-server/pull/5862

Comment 2 openshift-github-bot 2014-10-09 19:48:27 UTC

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

Comment 3 John M 2014-10-09 21:19:59 UTC

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.

Comment 4 Wenjing Zheng 2014-10-10 02:50:54 UTC

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.