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
