pg_dump file size

From: Mike angelo <angelocmp(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump file size
Date: 2009-04-14 15:33:30
Message-ID: 872577.50178.qm@web110309.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm a newb  running Postgres 8.3 on a SuSE 7.2 system. I have a database whose size reports as 644 MB using

select pg_size_pretty(pg_database_size('adempiere'));

When using the following command to back up the database,

su postgres -c "pg_dump adempiere | split -b 3000m - /tmp/adempiere_`date +%F`.dmp"
 
the result is a 49.5 MB file. Curious as to how the backup file can be less than 1/10th the size of the database?
 
Thanks,
 
-Mike

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Isabella Ghiurea 2009-04-14 15:38:42 pg error log file monitor
Previous Message ml@bortal.de 2009-04-14 11:46:43 Do the name of the WAL files matter?