| From: | Alex Lai <mlai(at)sesda3(dot)com> |
|---|---|
| To: | postgres general support <pgsql-general(at)postgresql(dot)org> |
| Subject: | Unable to log in current local time EST |
| Date: | 2016-08-25 15:36:21 |
| Message-ID: | e7f6e8fb-9412-147c-478e-e013dfd01308@sesda3.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear All,
I have my log_line_prefix set to
log_line_prefix = '[%d]%p %x %c[%l] %t %i'
in postgresql.conf
psql -c 'show timezone'
TimeZone
------------
US/Eastern
tail -2 omi_acps.log ; date
[sipsdb]20180 0 57ab7dcd.4ed4[11895717] 2016-08-25 15:32:45 GMT
SELECTLOG: duration: 0.326 ms
[sipsdb]20180 0 57ab7dcd.4ed4[11895718] 2016-08-25 15:32:45 GMT idle in
transactionLOG: statement: fetch all in "<unnamed portal 854341>"
Thu Aug 25 11:32:45 EDT 2016
My host is running EST time.
Postgres keeps log the GMT time.
I want to log EST time. How can I do that? Your help would be greatly
appreciated.
--
Best regards,
Alex Lai (:-)
OMP SIPS DBA ADNET Systems, Inc.
7515 Mission Drive, Suite A100
Lanham, MD 20706
301 352-4657 (phone)
301 352-0437 (fax)
mlai(at)sesda3(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Olarte | 2016-08-25 15:43:28 | Re: pg_hba.conf : bad entry for ADDRESS |
| Previous Message | arnaud gaboury | 2016-08-25 15:28:58 | Re: pg_hba.conf : bad entry for ADDRESS |