Обсуждение: pgsql_data/base mapping

Поиск
Список
Период
Сортировка

pgsql_data/base mapping

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



Re: pgsql_data/base mapping

От
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,


Re: pgsql_data/base mapping

От
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 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,
Pennsylvania19026