Re: Re: tables, where

On Thu, 29 Mar 2001, Mitch Vincent wrote:

> I'm confused as to how this could work.. The PGDATA environment variable
> (as I understand it) is used so that you don't need to supply a -D <data
> dir> argument to the postmaster at startup. If you had PGDATA and PGDATA2
> defined, how does the backend know which to use at startup without
> specifying something on the command line -- and if you're putting something
> on the command line anyway, why not just say -D <other data dir> ?

Mitch,

I no longer remember the specific syntax, but the -D wasn't working
whether or not another directory was specified as an environment variable.

In other words, only the default data directory would be seen as valid by
postgres. What I'm asking is if this has now been changed.

Thanks,

Rich

Dr. Richard B. Shepard, President

Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard(at)appl-ecosys(dot)com