Checking Postgres Database

Поиск
Список
Период
Сортировка
Искать

Checking Postgres Database

От:
"Ganesan Kanavathy" <ganesh@magnusquest.com>
Дата:
Dear all,
 
How to check database size for Posgresql db. I need give hardisk utilization of the database on daily basis.
 
Regards,
ganesh

Re: Checking Postgres Database

От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
On Tue, 7 Oct 2003, Ganesan Kanavathy wrote:

> Dear all,
>  
> How to check database size for Posgresql db. I need give hardisk
> utilization of the database on daily basis. 

Here's how I do it:

su - postgres
cd $PGDATA
du -s base

Re: Checking Postgres Database

От:
Harald Fuchs <nospam@sap.com>
Дата:
In article <000201c38cae$ffc059e0$2300a8c0@ganesh>,
"Ganesan Kanavathy"  writes:

> How to check database size for Posgresql db. I need give hardisk utilization
> of the database on daily basis.

contrib/dbsize is your friend.
FAQ