Re: configuring timezone

From: Terence Ferraro <terencejferraro(at)gmail(dot)com>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: configuring timezone
Date: 2013-02-06 23:47:19
Message-ID: CAEghcWAQNqJW0MJtVM3QwvOK78FjZFV_mim08Pi69eRYcDMbAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

9.2.1 was the version standard when I was building and deploying...so no, I
probably will not (personally) be updating anytime soon...

However, if you're interested, I'll see if I can find a place tonight or
tomorrow to put these binaries (they are 32-bit as well), source, etc
(sourceforge maybe?). I can also include to inno setup script that builds
an installer similar to the EnterpriseDB version; that is, it automatices
the service setup, creates a postgres user, etc. Hell, I may as well
include the pre-built installer, too, if you don't want to customize
anything..

In addition to the timezone fix, I (originally) wanted to build my own
Windows installer because the EnterpriseDB version does NOT link against
zlib with respect to openssl. In other words, no compressed ssl connections
are possible with the currently distributed windows version. This one is
linked against zlib (and the speed increase is quite significant).

T.J.

On Wed, Feb 6, 2013 at 3:23 PM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:

> I am on Windows (both 32 and 64 bit) using 32-bit Postgres.****
>
> So, your binaries are for 9.2.1, you aren’t planning to go to 9.2.2?****
>
> ** **
>
> ** **
>
> *From:* Terence Ferraro [mailto:terencejferraro(at)gmail(dot)com]
> *Sent:* Wednesday, February 06, 2013 3:07 PM
> *To:* Igor Neyman
> *Cc:* pgsql-general(at)postgresql(dot)org
> *Subject:* 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 <ineyman(at)perceptron(dot)com>
> wrote:****
>
> Terence,****
>
> ****
>
> Thanks for quick reply, I read your thread (Dec, 2012) before posting my
> question.****
>
> But, recompile is not an option for me. Was hoping, that something
> regarding this issue changed since…****
>
> ****
>
> Igor Neyman****
>
> ****
>
> *From:* Terence Ferraro [mailto:terencejferraro(at)gmail(dot)com]
> *Sent:* Wednesday, February 06, 2013 1:45 PM
> *To:* Igor Neyman
> *Cc:* pgsql-general(at)postgresql(dot)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 recompile if you want
> that behavior. Here's a diff applied against 9.2.1
> http://pastebin.com/5AyaX2RF. I've deployed the patched version a couple
> dozen times now and it is working flawlessly.
>
> T.J.****
>
> On Wed, Feb 6, 2013 at 1:32 PM, Igor Neyman <ineyman(at)perceptron(dot)com>
> 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.confentries
> timezone<http://www.postgresql.org/docs/9.2/static/runtime-config-client.html#GUC-TIMEZONE>and
> log_timezone<http://www.postgresql.org/docs/9.2/static/runtime-config-logging.html#GUC-LOG-TIMEZONE>accordingly (Tom Lane)
> ****
>
> This avoids expensive time zone probes during server start.****
>
> ****
>
> Question: is there any way to revert back to old behavior so that server
> will probe system’s timezone on startup (default to OS timezone on startup)
> instead setting it during initdb?****
>
> Obviously, without recompiling/rebuilding Postgres.****
>
> ****
>
> I’m dealing with the situation, where system is being built in one
> timezone (could be anywhere around the globe), and then moved to other (not
> known during system build) location with different timezone. ****
>
> After relocation, OS timezone will change, but we can’t allow user to edit
> timezone parameter in Postgresql.conf.****
>
> ****
>
> Regards,****
>
> Igor Neyman****
>
> ****
>
> ** **
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zach Seaman 2013-02-07 00:56:29 Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Previous Message Tom Lane 2013-02-06 22:11:22 Re: configuring timezone