Re: Data Loss After Restore?

Trevor Astrope <astrope(at)e-corp(dot)net> writes:
> I restored a 7.1.3 database to another machine which seems to have went
> fine. However, the data on the disk is less than the original machine...
> There is only 6.5GB in pgsql/dta/base on my test machine and the same
> directory on the production machine was at 8.4GB at the time of the dump.
> This was after a vacuum.

> I didn't see any errors when restoring the database, so I'm confused why
> the restored database takes up so much less space... Is there any reason
> why this would happen?

Index bloat in the old database, perhaps?

> Is there any easy way to see where I may have lost data?

Count rows in the tables, maybe. Also, if you still have the old DB
online, comparing reltuples & relpages columns in pg_class for both
databases (after a VACUUM, to be sure they're up to date) would tell
the tale.

regards, tom lane