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

On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery <monty@english.net> 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 = '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_timezone .  This is a new 'feature' in 9.2 that
annoyed me as well.  I assume that there was a good use case for this.