timezone change not in changelog ?
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-TIMEZONE
http://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/
Laurent Laborde <kerdezixe@gmail.com> writes:
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-TIMEZONE
http://www.postgresql.org/docs/9.1/static/runtime-config-client.html#GUC-TIMEZONE
ITYM this:
<listitem>
<para>
Identify the server time zone during <application>initdb</>, and set
<filename>postgresql.conf</filename> entries
<link linkend="guc-timezone"><varname>timezone</></link> and
<link linkend="guc-log-timezone"><varname>log_timezone</></link>
accordingly (Tom Lane)
</para>
<para>
This avoids expensive time zone probes during server start.
</para>
</listitem>
regards, tom lane