From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: timezone GUC |
Date: | 2011-09-13 13:37:45 |
Message-ID: | 1315921065.21410.1.camel@fsopti579.F-Secure.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On ons, 2011-09-07 at 17:16 -0400, Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
> > On Tue, Sep 6, 2011 at 23:52, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> >> On Tue, Sep 6, 2011 at 5:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >>> Although there's always more than one way to skin a cat. Consider
> >>> this idea:
> >>>
> >>> 1. The hard-wired default for timezone is always UTC (or something
> >>> else not dependent on environment).
> >>>
> >>> 2. We put the identify_system_timezone work into initdb, and have it
> >>> inject a non-default entry into postgresql.conf in the usual way
> >>> if it can identify what the system zone is.
> >>>
> >>> 3. Run-time dependency on TZ environment disappears altogether.
> >>>
> >>> This basically means that instead of incurring that search on every
> >>> postmaster start, we do it once at initdb. If you change the
> >>> postmaster's timezone environment, well, you gotta go change
> >>> postgresql.conf.
>
> >> Seems reasonable to me...
>
> > +1.
>
> I spent a bit of time on this idea last night. The most painful part
> actually seems to be translating identify_system_timezone to run in a
> non-backend environment (no elog, etc). The one thing I've run into
> that doesn't seem straightforward is to decide where to look for the
> timezone files. If we have --with-system-tzdata then of course it's a
> constant, but should we honor initdb's -L switch otherwise? And if so,
> how should we pass that into the pg_TZDIR code?
>
> regards, tom lane
>
It looks like the --with-system-tzdata case is somewhat broken now in
initdb:
creating configuration files ... could not open directory "...../pg-install/share/timezone": No such file or directory
ok
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2011-09-13 13:51:07 | Re: unite recovery.conf and postgresql.conf |
Previous Message | ktm@rice.edu | 2011-09-13 13:22:42 | Re: Patch to improve reliability of postgresql on linux nfs |