Re: [COMMITTERS] pgsql-server: Add code to identify_system_timezone() to try all zones in

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql-server: Add code to identify_system_timezone() to try all zones in
Date: 2004-05-26 03:09:52
Message-ID: 20040526030952.GA24543@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Tue, May 25, 2004 at 03:08:59PM -0300, Tom Lane wrote:

> Add code to identify_system_timezone() to try all zones in the zic
> database, not just ones that we cons up POSIX names for. This looks
> grim but it seems to take less than a second even on a relatively slow
> machine, and since it only happens once during postmaster startup, that
> seems acceptable.

Is it possible to execute this at initdb time to set the default
timezone in postgresql.conf? The user could get a message about what
timezone was selected, and be offered a --command-line-switch to select
a specific one.

Just an idea ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2004-05-26 03:42:04 Re: [COMMITTERS] pgsql-server: Add code to identify_system_timezone()
Previous Message Jan Wieck 2004-05-26 00:08:27 pgsql-server: Please apply this minor patch to the cvs HEAD of dbmirror

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-05-26 03:42:04 Re: [COMMITTERS] pgsql-server: Add code to identify_system_timezone()
Previous Message Christopher Kings-Lynne 2004-05-26 01:45:03 Re: Optimizer Bug issue