Re: Tables not restored from V7.4 to v8.1.4

[adey <adey11@xxxxxxxxx>]

We found corrupt data today in production that cannot be converted to UTF8. We are in the process of coorecting the data values. Thanks for your response.

On 7/19/06, Aaron Bono <postgresql@xxxxxxxxxx> wrote:

On 7/17/06, adey <adey11@xxxxxxxxx > wrote:

We recently backed up our production database (dumpall) on Postgres v7.4 and restored on v8.1.4. All of the tables restored except three. The tables were created, but their data wasn't applied. I can see the tables in the dump file, and no errors were reported in the restore. What am I missing please, and what should I check next?

You say you see the tables in the restore.  Do you see the data in the restore file as well?

==================================================================
 

   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
==================================================================