On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery <mo...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
