Thread: what is in ../data/base ??

what is in ../data/base ??

From
bk226157@skynet.be (pierre)
Date:
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.

Re: what is in ../data/base ??

From
Bruce Momjian
Date:
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

Re: what is in ../data/base ??

From
Frank Bax
Date:
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
>

Re: what is in ../data/base ??

From
Doug McNaught
Date:
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

Re: what is in ../data/base ??

From
Bruce Momjian
Date:
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

Re: what is in ../data/base ??

From
tony
Date:
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