Re: Detemine database size on Postgres 8.0 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Detemine database size on Postgres 8.0
Date
Msg-id dcc563d10903020952k136bb22ex747f771206f63f58@mail.gmail.com
Whole thread Raw
In response to Detemine database size on Postgres 8.0  (Thom Brown <thombrown@gmail.com>)
Responses Re: Detemine database size on Postgres 8.0  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
On Mon, Mar 2, 2009 at 8:25 AM, Thom Brown <thombrown@gmail.com> wrote:
> Hi all,
>
> We have a database server which is on version 8.0.12.  I was wondering if
> anyone knows of a way to tell the size of each database?

Back in the olden days when I was on 8.0 I would just use du -sh to find out.

sudo su - postgres
cd $PGDATA/base
oid2name
du -sh *

and match them up.  yeah, I had a script that made it prettier but
that worked fine.

If you're on windows I don't know what to tell you about doing these
things from the shell.

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Non-Fun with SSHA Password scheme
Next
From: K D
Date:
Subject: Re: Stalled post to pgsql-general