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
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?
pgsql-admin by date
|Next:||From: Isabella Ghiurea||Date: 2009-04-14 15:38:42|
|Subject: pg error log file monitor|
|Previous:||From: firstname.lastname@example.org||Date: 2009-04-14 11:46:43|
|Subject: Do the name of the WAL files matter?|