Thread: what is in ../data/base ??
Hello, I am currently using 7.1.3 on an HPUX-11.00 When I do a ls -al to look at the ../data/base directory here is what i see: postgres>ls -al total 52 drwx------ 7 postgres users 1024 Jan 1 18:05 . drwx------ 5 postgres sys 1024 Jan 1 17:46 .. drwx------ 2 postgres users 2048 Dec 17 21:40 1 drwx------ 2 postgres users 3072 Dec 31 14:56 184847 drwx------ 2 postgres users 2048 Dec 17 21:34 18719 drwx------ 2 postgres users 7168 Dec 17 22:51 58443 drwx------ 2 postgres users 10240 Jan 1 17:57 5886825 postgres>pwd /db1240/data/base postgres> I don't see the name of the databases I have created !! Idem inside a database directory. I don't see the name of the tables & index ! Only numbers ! Is it so since 7.1.3 ? It was not the case with 7.0.2 ! Any light on this ?? Have I done something wrong when installing 7.1.3 ? Thanks. Pierre.
pierre wrote: > Hello, > > I am currently using 7.1.3 on an HPUX-11.00 > When I do a ls -al to look at the ../data/base directory here is what i see: > > postgres>ls -al > total 52 > drwx------ 7 postgres users 1024 Jan 1 18:05 . > drwx------ 5 postgres sys 1024 Jan 1 17:46 .. > drwx------ 2 postgres users 2048 Dec 17 21:40 1 > drwx------ 2 postgres users 3072 Dec 31 14:56 184847 > drwx------ 2 postgres users 2048 Dec 17 21:34 18719 > drwx------ 2 postgres users 7168 Dec 17 22:51 58443 > drwx------ 2 postgres users 10240 Jan 1 17:57 5886825 > postgres>pwd > /db1240/data/base > postgres> > > I don't see the name of the databases I have created !! > Idem inside a database directory. I don't see the name of the tables & index ! > Only numbers ! > > Is it so since 7.1.3 ? It was not the case with 7.0.2 ! > Any light on this ?? Have I done something wrong when installing 7.1.3 ? See contrib/oid2name for mapping from numbers to names of databases and tables/indexes. -- 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
Try "select oid,* from pg_database" The numeric filenames are the oid. I don't know how to do the same for tables. Frank At 10:37 AM 1/1/02 -0800, pierre wrote: >Hello, > >I am currently using 7.1.3 on an HPUX-11.00 >When I do a ls -al to look at the ../data/base directory here is what i see: > >postgres>ls -al >total 52 >drwx------ 7 postgres users 1024 Jan 1 18:05 . >drwx------ 5 postgres sys 1024 Jan 1 17:46 .. >drwx------ 2 postgres users 2048 Dec 17 21:40 1 >drwx------ 2 postgres users 3072 Dec 31 14:56 184847 >drwx------ 2 postgres users 2048 Dec 17 21:34 18719 >drwx------ 2 postgres users 7168 Dec 17 22:51 58443 >drwx------ 2 postgres users 10240 Jan 1 17:57 5886825 >postgres>pwd >/db1240/data/base >postgres> > >I don't see the name of the databases I have created !! >Idem inside a database directory. I don't see the name of the tables & index ! >Only numbers ! > >Is it so since 7.1.3 ? It was not the case with 7.0.2 ! >Any light on this ?? Have I done something wrong when installing 7.1.3 ? > >Thanks. >Pierre. > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/users-lounge/docs/faq.html >
bk226157@skynet.be (pierre) writes: > I don't see the name of the databases I have created !! > Idem inside a database directory. I don't see the name of the tables & index ! > Only numbers ! Yes, this was changed in 7.1 to fix a couple of potential problems. The numbers are OIDs. You can use the 'oid2name' tool in the contrib/ directory to find out the name for a given number. > Is it so since 7.1.3 ? It was not the case with 7.0.2 ! > Any light on this ?? Have I done something wrong when installing 7.1.3 ? Nope, nothing wrong. ;) -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863
tony wrote: > You wrote: > > > > See contrib/oid2name for mapping from numbers to names of databases and > > tables/indexes. > > > Great !!! just what I needed too. > > On a side note Bryan White of pg_check fame did not respond to > my mail concerning compile failure of pg_check. Is he still > around??? Not sure. -- 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
You wrote: > See contrib/oid2name for mapping from numbers to names of databases and > tables/indexes. Great !!! just what I needed too. On a side note Bryan White of pg_check fame did not respond to my mail concerning compile failure of pg_check. Is he stillaround??? I still have to recover data from the crash before Xmas and my client is getting impatient. Cheers Tony Grant -- tony@animaproductions.com RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html