Re: About the pid and opts files - Mailing list pgsql-hackers

From Tom Lane
Subject Re: About the pid and opts files
Date
Msg-id 11736.961988876@sss.pgh.pa.us
Whole thread Raw
In response to Re: About the pid and opts files  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Failure scenario: Normally, TZ is unset. I log in remotely from a
> different time zone to administer a database server so I have TZ set to
> override the system's default time zone. I `su postgres', do something,
> pg_ctl restart. All the sudden the server operates with a different
> default time zone. This is not an unrealistic situation, I have done this
> many times.

Right --- it should be *possible* to change these vars, but it should
take some explicit action.  Having a different value in your environment
at postmaster start time is probably not enough of an explicit action.

This whole thread makes me more and more uncomfortable about the fact
that the postmaster/backend pay attention to environment variables at
all.  An explicit configuration file would seem a better answer.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: CLASSOID patch
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] RE: CLASSOID patch