On Tuesday 13 April 2004 01:14, Kevin Brown wrote:
> Tom Lane wrote:
<snip>
> To be honest, I think the use of the PG_DATA environment variable is the
> biggest impediment to "self documentation" - the postmaster should not
> use it.
>
> The reason is that if PG_DATA is used to specify the location of the
> data directory, you won't be able to find out where a running
> postmaster's data directory is located without doing some heavy-duty
> investigation. Not all operating systems make it possible to determine
> the values of a particular process' environment variables.
>
I think this is another vote for "store the PGDATA dir value inside a running
postgresql" so you can query the running database to find out what datafiles
it is using.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL