Thread

1. how to find DB names in Postgres 7.1?

   Limin Liu <limin@pumpkinnet.com> — 2001-03-06T20:47:35Z

   In Postgres 7.1, ${PGDATA}/base contains directories named by
   numbers!!   They used to be database names.   If a user created a db,
   can the db admin know what is that db name (without sending any query to
   db server)?
   
   I believe there must have some kind of mapping table exist.  Can anyone
   tell me where to find it?
   
   Thanx for your help
   
   LM.Liu
   
   

2. Re: how to find DB names in Postgres 7.1?

   Randy Hall <rhall@greatbridge.com> — 2001-03-06T22:10:02Z

   Look in the contrib directory for oid2name.  This program will do what
   you are looking for.
   
   Limin Liu wrote:
   > 
   > In Postgres 7.1, ${PGDATA}/base contains directories named by
   > numbers!!   They used to be database names.   If a user created a db,
   > can the db admin know what is that db name (without sending any query to
   > db server)?
   > 
   > I believe there must have some kind of mapping table exist.  Can anyone
   > tell me where to find it?
   > 
   > Thanx for your help
   > 
   > LM.Liu
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 4: Don't 'kill -9' the postmaster
   
   -- 
   ---------------------------------------------------
   Randy Hall                    Great Bridge, LLC
   Sr. Knowledge Engineer        253 Monticello Avenue
   Red Hat Certified Engineer    Norfolk, VA 23410