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.
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?