On 21.03.2007, at 11:25, Karthikeyan Sundaram wrote:
Our database is growing fast. I want to create a cronjob that should tell me what is the current size of the database on each day.How can I find this from the database? Is there any pre-written scripts written by somebody to share?
Be aware of linebreaks ...[Galadriel: cug ] cug $ psql -U postgres -c "select pg_size_pretty (pg_database_size('testdb'));"
pg_size_pretty ---------------- 495 MB (1 row)
