Re: Re: tables, where - Mailing list pgsql-general

From Rich Shepard
Subject Re: Re: tables, where
Date
Msg-id Pine.LNX.4.30.0103291008480.31443-100000@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: tables, where  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-general
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@appl-ecosys.com


pgsql-general by date:

Previous
From: Soma Interesting
Date:
Subject: Re: timestamp/function question
Next
From: Rich Shepard
Date:
Subject: Re: tables, where