Friendly greetings !
There is a change between 9.1 and 9.2 that doesn't seems to be in the
changelog :
http://www.postgresql.org/docs/9.2/static/runtime-config-client.html#GUC-TIMEZONEhttp://www.postgresql.org/docs/9.1/static/runtime-config-client.html#GUC-TIMEZONE
* in 9.1 the default timezone is the system timezone :
timezone (string)
Sets the time zone for displaying and interpreting time stamps. If not
explicitly set, the server initializes this variable to the time zone
specified by its system environment. See Section 8.5.3 for more
information.
* in 9.2 the default timezone is GMT :
TimeZone (string)
Sets the time zone for displaying and interpreting time stamps. The
built-in default is GMT, but that is typically overridden in
postgresql.conf; initdb will install a setting there corresponding to
its system environment. See Section 8.5.3 for more information.
--
Laurent "ker2x" Laborde
Sysadmin & DBA at http://www.over-blog.com/