configuring timezone

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: configuring timezone
Date: 2013-02-06 18:32:22
Message-ID: A76B25F2823E954C9E45E32FA49D70EC08F788EB@mail.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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<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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wells Oliver 2013-02-06 18:41:03 Keeping historical record changes w/ triggers - best practices?
Previous Message Steven Schlansker 2013-02-06 18:04:54 Re: best config