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
