Postgresql logfilename and times in GMT - not EST

From: Bryan Montgomery <monty(at)english(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql logfilename and times in GMT - not EST
Date: 2012-12-04 21:59:21
Message-ID: CAPTJ3=cQ3h3Fx+0HrG_7JaxDe7k_jeAgbRxvWP9k4QGOJ8t_cg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a test 9.2.0 db running on openSuse 12.2. When I select now() I get
the correct timezone and date back (-5 hours).
When I do date at the os prompt, I get the right timezone back.

I changed postgres.conf to have timezone = 'EST' and restarted postgres.
However the log file is still 5 hours ahead. What gives? Not the end of the
world but a bit annoying.

Bryan.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2012-12-04 22:03:28 Re: Postgresql logfilename and times in GMT - not EST
Previous Message Pavel Stehule 2012-12-04 21:14:55 Re: Which is faster: char(14) or varchar(14)