| From: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
|---|---|
| To: | Joe Block <jpb(at)ApesSeekingKnowledge(dot)net> |
| Cc: | pgsql novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Database size |
| Date: | 2002-02-12 20:11:32 |
| Message-ID: | 87r8nq7957.fsf@npa01zz001.simplot.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
man du :)
Actually if you look in the PostgreSQL data directory you will see a
folder for each database. Unfortunately they all have numbers that
match up with the oid of the database instead of something like
larrys_database.
There is a program in contrib (oid2name) that matches these numbers up
with the database name.
Jason
Joe Block <jpb(at)ApesSeekingKnowledge(dot)net> writes:
> I'm doing some work for an ISP, and need to be able to tell how large
> a database is for billing purposes. I looked in the docs and checked
> the list archives, but didn't find anything.
>
> It seems like this would be a common thing to check.
>
> thanks,
>
> jpb
> --
> Joe Block <jpb(at)ApesSeekingKnowledge(dot)net>
>
> Eve succumbed to the tempation of the Apple.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Singer Wang | 2002-02-12 20:19:54 | varchar vs char vs text |
| Previous Message | Joe Block | 2002-02-12 16:08:35 | Database size |