Re: [GENERAL] PG vs MySQL (fwd)

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