tradein_clients=# SELECT oid,datname from pg_database;
oid| datname
--+-
27856881 | test
7865515 | sysstat
8990396 | access_log
16555 | template0
378968 | tradein_clients
378969 | rt2
1 | template1
(7 rows)
also gives the same info.
is it r
Gary Stainburn wrote:
> Hi all,
>
> Below is the output from 'du -kx /|sort -rn|head'. It's showing that
> /var/lib/pgsql/data/base/46169 is using a big chunk of my disk.
>
> How can I tell which DB this is?
> What suggestions can people make to reduce the amount of disk space used by
