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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])