Data Loss After Restore?

From: Trevor Astrope <astrope(at)e-corp(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Data Loss After Restore?
Date: 2002-04-03 15:55:54
Message-ID: Pine.LNX.4.33.0204031049510.2959-100000@gord.hip.tabbweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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? Is there any easy way to see where I may have lost
data?

Let me know if I can supply any additional info that may help.

Any help is appreciated.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Langille 2002-04-03 16:11:50 Re: Data Loss After Restore?
Previous Message Tom Lane 2002-04-03 15:55:31 Re: INDEX issues