pgsql_data/base mapping
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?
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
Show quoted text
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,
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