
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 my....bus?


Mon, 6 May 2002 16:31:00 -0700 (PDT)
Laurette Cisneros <laurette@nextbus.com>
pgsql_data/base mapping
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,

Mon, 6 May 2002 16:42:51 -0700
Jeff Davis <list-pgsql-hackers@empires.org>
Re: pgsql_data/base mapping
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
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 3 Jun 2002 13:25:01 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: pgsql_data/base mapping