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
On Mon, Mar 2, 2009 at 8:25 AM, Thom Brown 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
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?
I've tried:
select pg_size_pretty(pg_database_size('test'));
which doesn't work because pg_database_size is unrecognised. And I've
tried:
select *
from
