Thread: Checking Postgres Database

Checking Postgres Database

From
"Ganesan Kanavathy"
Date:
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

From
"scott.marlowe"
Date:
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

From
Harald Fuchs
Date:
In article <000201c38cae$ffc059e0$2300a8c0@ganesh>,
"Ganesan Kanavathy" <ganesh@magnusquest.com> 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.