Re: [GENERAL] PG vs MySQL (fwd) - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: [GENERAL] PG vs MySQL (fwd)
Date
Msg-id 20040329062411.S51637@ganymede.hub.org
Whole thread Raw
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: int2[] vs int2vector in pg_catalog?
Next
From: Fabien COELHO
Date:
Subject: Re: pg_advisor schema proof of concept