Postgres Pro
Downloads
Home   >   mailing lists

pg_dump file size - Mailing list pgsql-admin

From Mike angelo
Subject pg_dump file size
Date
Msg-id 872577.50178.qm@web110309.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: pg_dump file size  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Finding out on exactly what I am stuck
Next
From: Tom Lane
Date:
Subject: Re: pg_dump file size