Excerpts from Tom Lane's message of vie sep 09 18:59:45 -0300 2011:
Simplify handling of the timezone GUC by making initdb choose the default.

We were doing some amazingly complicated things in order to avoid running
the very expensive identify_system_timezone() procedure during GUC
initialization. But there is an obvious fix for that, which is to do it
once during initdb and have initdb install the system-specific default into
postgresql.conf, as it already does for most other GUC variables that need
system-environment-dependent defaults. This means that the timezone (and
log_timezone) settings no longer have any magic behavior in the server.
Per discussion.
Hmm, I was hoping that this might open the door for setting a nonempty
default log_line_prefix, but apparently not :-( Seems
setup_formatted_start_time is still expecting that GUC initialization
would be called before we do anything with it. Pity ...

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Search Discussions

  • Tom Lane at Sep 10, 2011 at 2:42 am

    Alvaro Herrera writes:
    Excerpts from Tom Lane's message of vie sep 09 18:59:45 -0300 2011:
    Simplify handling of the timezone GUC by making initdb choose the default.
    Hmm, I was hoping that this might open the door for setting a nonempty
    default log_line_prefix, but apparently not :-( Seems
    setup_formatted_start_time is still expecting that GUC initialization
    would be called before we do anything with it. Pity ...
    I think it actually would work now, you'd just have to accept that any
    log messages that come out during GUC initialization might appear in GMT.
    I didn't really experiment with that angle of it --- feel free.

    But having said that, I'm not sure that there's a consensus for changing
    the default log_line_prefix.

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedSep 10, '11 at 1:32a
activeSep 10, '11 at 2:42a
posts2
users2
websitepostgresql.org...
irc#postgresql

2 users in discussion

Tom Lane: 1 post Alvaro Herrera: 1 post

People

Translate

site design / logo © 2022 Grokbase