Обсуждение: 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 <linklinkend="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