On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery <monty(at)english(dot)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.