Re: [HACKERS] pgsql_data/base mapping

2002-06-03 Thread Bruce Momjian 

Laurette Cisneros wrote:
 
 Are the numbers of the directories in the base diretory and the numbers of
 the directories under that, etc. traceable to a reference somewhere in the
 postgresql server using that data directory (such as the pg_database table
 or such)?  If so, is there somewhere this is documented?

You can use /contrib/oid2name to get the database names and table names
from the oid file numbers.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 853-3000
  +  If your life is a hard drive, |  830 Blythe Avenue
  +  Christ can be your backup.|  Drexel Hill, Pennsylvania 19026

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[HACKERS] pgsql_data/base mapping

2002-05-06 Thread Laurette Cisneros 


Are the numbers of the directories in the base diretory and the numbers of
the directories under that, etc. traceable to a reference somewhere in the
postgresql server using that data directory (such as the pg_database table
or such)?  If so, is there somewhere this is documented?

Thanks,

-- 
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Where's mybus?


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] pgsql_data/base mapping

2002-05-06 Thread Jeff Davis 

The numbers are the same as the oids found in pg_database (as you expected). 

This question is better suited for the -general list, for future reference.

Regards,
Jeff

On Monday 06 May 2002 04:31 pm, Laurette Cisneros wrote:
 Are the numbers of the directories in the base diretory and the numbers of
 the directories under that, etc. traceable to a reference somewhere in the
 postgresql server using that data directory (such as the pg_database table
 or such)?  If so, is there somewhere this is documented?

 Thanks,

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org