Re: Checking Postgres Database

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Ganesan Kanavathy <ganesh(at)magnusquest(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Checking Postgres Database
Date: 2003-10-07 14:29:39
Message-ID: Pine.LNX.4.33.0310070829250.11210-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message scott.marlowe 2003-10-07 14:35:41 Re: Pgsql crashes frequently
Previous Message Priya G 2003-10-07 14:22:01 t help PostgreSQL server: FATAL 1: S