
He brings up two good points here ... first one being, where exactly, in
the docs, do we mention getting the OID in either pg_database, or
pg_class, to determine a directory, or file name?  I just checked the
pg_database catalog page, and it doesn't ...

Second point, of course being ... how do you find a database if the server
isn't running?  Could we maybe have a file in each directory similar to
PG_VERSION calld PG_DATABASE that just contains the name of the database,
that you could grep through for the database?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

---------- Forwarded message ----------
Date: Sun, 28 Mar 2004 22:37:41 -0600 (CST)
From: Mike Nolan <nolan@gw.tssi.com>
To: Marc G. Fournier <scrappy@postgresql.org>
Cc: Alex <alex@meerkatsoft.com>, Frank Finner <postgresql@finner.de>,
     pgsql-general@postgresql.org
Subject: Re: [GENERAL] PG vs MySQL

> > Perhaps, but it isn't obvious which directory has which database.  I'm not
> > not sure which system catalogs provide that information, something that
> > wasn't obvious from the online docs, either.
>
> SELECT oid FROM pg_database WHERE datname = '<database>';

Thanks.  That should be easier to find in the documentation, perhaps it
should be mentioned in the docs for the pg_database system catalog.

 From an ISP's or DBA's point of view, it would be preferable if there was
a way to determine which directory held which database without having
to actually log into the database.  I can envision circumstances under
which postmaster might not be running when that information is needed.
--
Mike Nolan

Mon, 29 Mar 2004 06:27:47 -0400 (AST)
"Marc G. Fournier" <scrappy@postgresql.org>
Re: [GENERAL] PG vs MySQL (fwd)