Search Postgresql Archives

Re: Detemine database size on Postgres 8.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Mar 2, 2009 at 8:25 AM, Thom Brown <thombrown@xxxxxxxxx> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux