From: | Laurent Laborde <kerdezixe(at)gmail(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | timezone change not in changelog ? |
Date: | 2012-10-17 11:49:14 |
Message-ID: | CAEy3c_S0aYYWhHOko7cC8Qmh7u2ROpqH8nzJVFtcvCV81ejTQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | P. Christeas | 2012-10-17 12:38:41 | [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows |
Previous Message | Amit Kapila | 2012-10-17 11:46:04 | Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown |