Thread: Unable to log in current local time EST
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@sesda3.com
Hi, On Thu, 2016-08-25 at 11:36 -0400, Alex Lai wrote: > 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? What is the value of log_timezone parameter? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
On 08/25/2016 11:36 AM, Alex Lai wrote: > 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. > > > Actually, I found the problem. I missed the parameter log_timezone. It took by default as GMT. I added log_timezone=US/Eastern and run pg_ctl reload. It works. -- 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@sesda3.com