Postgres Pro
Downloads
Home   >   mailing lists

Re: Tables not restored from V7.4 to v8.1.4 - Mailing list pgsql-admin

From adey
Subject Re: Tables not restored from V7.4 to v8.1.4
Date
Msg-id 1c66bda80607190048u382b91bw6450b03d25da8156@mail.gmail.com
Whole thread Raw
In response to Re: Tables not restored from V7.4 to v8.1.4  ("Aaron Bono" <postgresql@aranya.com>)
List pgsql-admin
Tree view
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@aranya.com> wrote:
On 7/17/06, adey <adey11@gmail.com > 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
==================================================================

pgsql-admin by date:

Previous
From: John DeSoi
Date:
Subject: Re: is there any dataware housing tools for postgresql
Next
From: "Merlin Moncure"
Date:
Subject: Re: [GENERAL] is there any dataware housing tools for postgresql