Re: [GENERAL] configuring timezone

2013-02-07 Thread Igor Neyman
.com>] Sent: Wednesday, February 06, 2013 1:45 PM To: Igor Neyman Cc: pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org> Subject: Re: [GENERAL] configuring timezone See the archived thread here: http://www.postgresql.org/message-id/CAEghcWD8DXjroBYCZsdGrx+cHTCbCbW9es2uQ+o7a

Re: [GENERAL] configuring timezone

2013-02-06 Thread Igor Neyman
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 writes

Re: [GENERAL] configuring timezone

2013-02-06 Thread Terence Ferraro
t; ** ** > > *From:* Terence 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 t

Re: [GENERAL] configuring timezone

2013-02-06 Thread Tom Lane
Igor Neyman 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 database installed).

Re: [GENERAL] configuring timezone

2013-02-06 Thread Adrian Klaver
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 avoi

Re: [GENERAL] configuring timezone

2013-02-06 Thread Igor Neyman
> -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 Ne

Re: [GENERAL] configuring timezone

2013-02-06 Thread Adrian Klaver
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 ti

Re: [GENERAL] configuring timezone

2013-02-06 Thread Igor Neyman
t: Re: [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 mailto:iney...@perceptron.com>> wrote: Terence, Thanks

Re: [GENERAL] configuring timezone

2013-02-06 Thread Terence Ferraro
om] > *Sent:* Wednesday, February 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+cHTCb

Re: [GENERAL] configuring timezone

2013-02-06 Thread Igor Neyman
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 ne

Re: [GENERAL] configuring timezone

2013-02-06 Thread Terence Ferraro
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 dep

[GENERAL] configuring timezone

2013-02-06 Thread Igor Neyman
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 timezone