From: | Kris Deugau <kdeugau(at)webhart(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database directory names |
Date: | 2002-07-03 21:49:19 |
Message-ID: | 3D23715F.BC9D11F0@webhart.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> Stephan Szabo wrote:
> > Switching to numbers for tables and databases helped a few things
> > (including for tables making it easier to rollback a drop table).
> > There's a contrib item, oid2name which will print out a mapping
> > of directory number to database name. The readme gives an example
> > of using it with du.
Ah, option number 3. I *thought* there had to be a good reason for it,
but I couldn't imagine how it might help. (I still can't, but I'm not
in any way an expert on DBMS programming.)
Bruce Momjian wrote:
> Uh, actually, only the readme in the current CVS has the example, 7.2.X
> doesn't. I recommend getting oid2name from the snapshot/CVS and using
> that. It has the newer readme and some changes to make the examples
> display properly. Also see the new doc section for 7.3 on disk usage:
> http://developer.postgresql.org/docs/postgres/diskusage.html
Snagged, tested, and I'm happy. Thanks for the heads-up on where to
find oid2name.
-Kris
WebHart Internet Linux Sysadmin
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond Fung | 2002-07-04 02:00:01 | ecpg problem : pre-processor translated long constant to char |
Previous Message | Robert Treat | 2002-07-03 21:44:06 | Re: PostGre SQL on linux |