X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id AB21F9FA434 for ; Wed, 19 Jul 2006 04:48:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 04729-10 for ; Wed, 19 Jul 2006 07:48:37 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id E93CC9FA430 for ; Wed, 19 Jul 2006 04:48:36 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so184371ugc for ; Wed, 19 Jul 2006 00:48:34 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=V5l6KMpWzTqfMTc+oMiKJVwJRenlGLV6Boq2G1yzosiM6InNN7sqRIdNy9hT4oVTJF2UHy6dPVvgBmPofozLt2X7L4blrY9mNdX3iN1o0kJG6E1mKW+Xzd7ff6xq76F1JUtYuT7Li/k7zNRPSnJB30Voh4smI5cKMHyciHZPY9E= Received: by 10.66.240.12 with SMTP id n12mr410525ugh; Wed, 19 Jul 2006 00:48:34 -0700 (PDT) Received: by 10.66.241.4 with HTTP; Wed, 19 Jul 2006 00:48:34 -0700 (PDT) Message-ID: <1c66bda80607190048u382b91bw6450b03d25da8156@mail.gmail.com> Date: Wed, 19 Jul 2006 19:48:34 +1200 From: adey To: "Aaron Bono" Subject: Re: Tables not restored from V7.4 to v8.1.4 Cc: "pgsql-admin@postgresql.org" , postgresql-l In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_123370_25197482.1153295314641" References: <1c66bda80607171750j49b271cfvdd88b61c7252aa88@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/156 X-Sequence-Number: 22402 ------=_Part_123370_25197482.1153295314641 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 wrote: > > On 7/17/06, adey wrote: > > > > We recently backed up our production database (dumpall) on Postgres v7.4and 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 > ================================================================== > ------=_Part_123370_25197482.1153295314641 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
==================================================================

------=_Part_123370_25197482.1153295314641--