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.