On Wed, Jan 19, 2011 at 3:00 PM, Ahmed Ossama <ahmed@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
