Re: Detemine database size on Postgres 8.0

On Mon, 2 Mar 2009, Scott Marlowe wrote:

> Back in the olden days when I was on 8.0 I would just use du -sh to find
> out. and match them up.  yeah, I had a script that made it prettier but
> that worked fine.

Not sure what version I started using this trick on:

SELECT relfilenode, relpages * 8 AS kb FROM pg_class;

But that might have been 8.0.

There is an example of a script like you describe on starting on P88 of
Bruce's presentation at

http://momjian.us/main/writings/pgsql/administration.pdf

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD