Postgres Pro
Downloads
Home   >   mailing lists

Postgresql logfilename and times in GMT - not EST - Mailing list pgsql-general

From Bryan Montgomery
Subject Postgresql logfilename and times in GMT - not EST
Date
Msg-id CAPTJ3=cQ3h3Fx+0HrG_7JaxDe7k_jeAgbRxvWP9k4QGOJ8t_cg@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql logfilename and times in GMT - not EST  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Which is faster: char(14) or varchar(14)
Next
From: Lonni J Friedman
Date:
Subject: Re: Postgresql logfilename and times in GMT - not EST