On Tue, Dec 4, 2012 at 2:42 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery wrote:
>>> 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
>>> w
Lonni J Friedman writes:
> On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery wrote:
>> 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.
> you need to set log_timezon
On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery wrote:
> 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 = 'E
