Re: alternative DB locations - Mailing list pgsql-general

From Tom Lane
Subject Re: alternative DB locations
Date
Msg-id 17780.970585914@sss.pgh.pa.us
Whole thread Raw
In response to Re: alternative DB locations  (Jeff Hoffmann <jeff@propertykey.com>)
Responses Re: alternative DB locations  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Jeff Hoffmann <jeff@propertykey.com> writes:
> not to be pedantic, but just to make sure, i looked in the 7.0 docs and
> it says it plain as day on the "alternate locations" section from the
> admin guide, second paragraph "This
> environment variable must have been defined before the backend was
> started"  this is an incredibly common question for being spelled out
> that directly in the documentation.  this statement should probably be
> bold or italic or otherwise emphasized,

Actually, first it should be *corrected*.  It should say "... defined
before the POSTMASTER is started".  Or even more directly, "... supplied
in the postmaster's environment variable set".

As is, it can reasonably be read that you just have to define the variable
in your own environment before starting a psql session (which starts a
backend of course).

The critical distinction that people aren't making is between their
client environment and the postmaster/backend environment, and the
existing text doesn't seem to help them.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Hoffmann
Date:
Subject: Re: alternative DB locations
Next
From: Tom Lane
Date:
Subject: Re: trouble with trigger/function???