Postgres Pro
Downloads
Home   >   mailing lists

Thread: /var/lib/postgres/data/base/?

/var/lib/postgres/data/base/?

From
will trillich
Date:
in the old days ( <= 7.0.3 ) we could tell which database and
which table we were looking at in the filesystem...

now i've got lots of

# ls /var/lib/postgres/data/base/
1  18719  18786  18824  19544  19564  19682  26790  56992  64418
76436

# ls /var/lib/postgres/data/base/76436/
1215   1255   16617  16934  17058  17103  17118  17139  17154
17169  17184  17201  17243  17276  78222  78288  78352  1216
1259   16642  16948  17074  17106  17121  17142  17157  17172
17187  17213  17246  17288  78241  78292  78364  1219   16567
16653  16960  17086  17109  17124  17145  17160  17175  17190
17216  17258  78187  78253  78311  PG_VERSION    1247   16579
16685  17033  17097  17112  17133  17148  17163  17178  17193
17228  17261  78206  78257  78323  pg_internal.init     1249
16600  16867  17045  17100  17115  17136  17151  17166  17181
17196  17231  17273  78218  78276  78327

is there a simple way of seeing which files are which relations
(or which databases, for that matter)?

and (or) a quick way to know the data-size of a row in any
table?

--
I'd concentrate on "living in the now" because it is fun
and on building a better world because it is possible.
    - Tod Steward

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Re: /var/lib/postgres/data/base/?

From
newsreader@mediaone.net
Date:
The following command should tell
you what you need.

=> select relfilenode,relname from pg_class where relname !~ '^pg';

hth


On Wed, Jul 25, 2001 at 12:19:59AM -0500, will trillich wrote:
> in the old days ( <= 7.0.3 ) we could tell which database and
>
> is there a simple way of seeing which files are which relations

Re: /var/lib/postgres/data/base/?

From
Bruce Momjian
Date:
There is a /contrib module called oid2name that does this.

> in the old days ( <= 7.0.3 ) we could tell which database and
> which table we were looking at in the filesystem...
>
> now i've got lots of
>
> # ls /var/lib/postgres/data/base/
> 1  18719  18786  18824  19544  19564  19682  26790  56992  64418
> 76436
>
> # ls /var/lib/postgres/data/base/76436/
> 1215   1255   16617  16934  17058  17103  17118  17139  17154
> 17169  17184  17201  17243  17276  78222  78288  78352  1216
> 1259   16642  16948  17074  17106  17121  17142  17157  17172
> 17187  17213  17246  17288  78241  78292  78364  1219   16567
> 16653  16960  17086  17109  17124  17145  17160  17175  17190
> 17216  17258  78187  78253  78311  PG_VERSION    1247   16579
> 16685  17033  17097  17112  17133  17148  17163  17178  17193
> 17228  17261  78206  78257  78323  pg_internal.init     1249
> 16600  16867  17045  17100  17115  17136  17151  17166  17181
> 17196  17231  17273  78218  78276  78327
>
> is there a simple way of seeing which files are which relations
> (or which databases, for that matter)?
>
> and (or) a quick way to know the data-size of a row in any
> table?
>
> --
> I'd concentrate on "living in the now" because it is fun
> and on building a better world because it is possible.
>     - Tod Steward
>
> will@serensoft.com
> http://sourceforge.net/projects/newbiedoc -- we need your brain!
> http://www.dontUthink.com/ -- your brain needs us!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

--
  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