Re: PG vs MySQL

On Sun, 28 Mar 2004, Mike Nolan wrote:

> > > 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.

Two valid points ... I've brought them up onto hackers to see about
getting both rectified ...

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