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: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---------- Forwarded message ---------- Date: Sun, 28 Mar 2004 22:37:41 -0600 (CST) From: Mike Nolan <[EMAIL PROTECTED]> To: Marc G. Fournier <[EMAIL PROTECTED]> Cc: Alex <[EMAIL PROTECTED]>, Frank Finner <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
