Re: Database size

Поиск
Список
Период
Сортировка
От Jason Earl
Тема Re: Database size
Дата
Msg-id 87r8nq7957.fsf@npa01zz001.simplot.com
обсуждение исходный текст
Ответ на Database size  (Joe Block <jpb@ApesSeekingKnowledge.net>)
Список 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@ApesSeekingKnowledge.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@ApesSeekingKnowledge.net>
>
> Eve succumbed to the tempation of the Apple.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

В списке pgsql-novice по дате отправления:

Предыдущее
От: Singer Wang
Дата:
Сообщение: varchar vs char vs text
Следующее
От: Jason Earl
Дата:
Сообщение: Re: varchar vs char vs text