: Wednesday, February 06, 2013 1:45 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.orgmailto:pgsql-general@postgresql.org
Subject: Re: [GENERAL] configuring timezone
See the archived thread here:
http://www.postgresql.org/message-id/CAEghcWD8DXjroBYCZsdGrx+cHTCbCbW9es2uQ+o7a8NZ61JT=q...@mail.gmail.com
Timezone configuration parameter (defaulting to system timezone) worked fine
for us before upgrading from 8.4. to 9.2.
Now we've got a problem.
9.2 Release Notes says:
* Identify the server time zone during initdb, and set postgresql.conf entries
See the archived thread here:
http://www.postgresql.org/message-id/CAEghcWD8DXjroBYCZsdGrx+cHTCbCbW9es2uQ+o7a8NZ61JT=q...@mail.gmail.com
Short version: Sorry, but you're going to need to recompile if you want
that behavior. Here's a diff applied against 9.2.1
http://pastebin.com/5AyaX2RF. I've
06, 2013 1:45 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] configuring timezone
See the archived thread here:
http://www.postgresql.org/message-id/CAEghcWD8DXjroBYCZsdGrx+cHTCbCbW9es2uQ+o7a8NZ61JT=q...@mail.gmail.com
Short version: Sorry, but you're going to need
*To:* Igor Neyman
*Cc:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] configuring timezone
** **
See the archived thread here:
http://www.postgresql.org/message-id/CAEghcWD8DXjroBYCZsdGrx+cHTCbCbW9es2uQ+o7a8NZ61JT=q...@mail.gmail.com
Short version: Sorry, but you're going to need
: [GENERAL] configuring timezone
Sorry, but from what I understand the change is permanent. If recompile is not
an option but you're on Windows let me know; I do have binaries available..
On Wed, Feb 6, 2013 at 2:05 PM, Igor Neyman
iney...@perceptron.commailto:iney...@perceptron.com wrote:
Terence
On 02/06/2013 10:32 AM, Igor Neyman wrote:
Timezone configuration parameter (defaulting to system timezone) worked
fine for us before upgrading from 8.4. to 9.2.
Now we’ve got a problem.
9.2 Release Notes says:
· Identify the server time zone during initdb, and set postgresql.conf
entries
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Wednesday, February 06, 2013 4:40 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] configuring timezone
On 02/06/2013 10:32 AM, Igor Neyman wrote:
Timezone configuration
On 02/06/2013 01:47 PM, Igor Neyman wrote:
--
Adrian Klaver
adrian.kla...@gmail.com
Sometimes, but not always.
I guess you could ship a script that sets the timezone
when the server is installed.
Going back to the reason for this change in Release Notes:
This avoids expensive
Igor Neyman iney...@perceptron.com writes:
Going back to the reason for this change in Release Notes:
This avoids expensive time zone probes during server start.
How expensive?
The time zone probe logic involves reading every file under
/usr/share/zoneinfo (or wherever you have the Olson tz
Ferraro [mailto:terencejferr...@gmail.com]
*Sent:* Wednesday, February 06, 2013 3:07 PM
*To:* Igor Neyman
*Cc:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] configuring timezone
** **
Sorry, but from what I understand the change is permanent. If recompile is
not an option
Thank you for explaining.
Regards,
Igor Neyman
From: Tom Lane [t...@sss.pgh.pa.us]
Sent: Wednesday, February 06, 2013 5:11 PM
To: Igor Neyman
Cc: Adrian Klaver; pgsql-general@postgresql.org
Subject: Re: [GENERAL] configuring timezone
Igor Neyman iney
12 matches
Mail list logo