Re: determining database size

Jeff Davis wrote:
> I would just like to know how to determine the size of a database. The
> directories inside the data directory are numerical, so I can't associate
> them with a particular database or table.
>
> I would basically just like to create reports so I can determine how fast the
> disk usage is increasing.
>
> Any suggestions?
>

Try:
test=# select oid, datname from pg_database;
   oid  |  datname
-------+-----------
  16613 | test
      1 | template1
  16560 | template0
  16671 | test2


[postgres@jec-linux dblink]$ cd $PGDATA
[postgres@jec-linux data]$ cd base
/opt/data/pgsql/data/base
[postgres@jec-linux base]$ ls
total 24
drwx------    6 postgres postgres     4096 Apr 16 10:44 .
drwx------    6 postgres postgres     4096 Apr 17 10:53 ..
drwx------    2 postgres postgres     4096 Apr 16 10:43 1
drwx------    2 postgres postgres     4096 Apr 16 10:42 16560
drwx------    2 postgres postgres     4096 Apr 16 10:44 16613
drwx------    2 postgres postgres     4096 Apr 16 10:44 16671


And you can see which directory is which database. There is also
something in ~/pgsql/contrib/oid2name that you might want to look at
(never used it myself though).

HTH,

Joe