On Wed, Jan 19, 2011 at 3:00 PM, Ahmed Ossama <ahmed(at)aossama(dot)net> wrote:
> Am I making an accurate comparison between the original db and the one i am
> trying to dump by comparing their sizes?
>
No.
What you might want to do is take a pg_dump of the newly restored DB
and see if its size is comparable to the size of the original dump.
These are in a compact format. The on-disk format of the database
probably has some extra space in it from processing updates and
deletes over time.
The other option is to count the number of rows per table and compare those.