| From: | Devrim Gündüz <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Alex Lai <mlai(at)sesda3(dot)com>, postgres general support <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Unable to log in current local time EST |
| Date: | 2016-08-25 21:03:47 |
| Message-ID: | 1472159027.10492.18.camel@gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ahsan Ali | 2016-08-25 22:54:34 | Re: LOG: could not fork new process for connection: Cannot allocate memory |
| Previous Message | Alex Lai | 2016-08-25 20:59:04 | Re: Unable to log in current local time EST |