X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 612EC9FB322 for ; Tue, 18 Jul 2006 13:07:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 42783-03-2 for ; Tue, 18 Jul 2006 13:07:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 23ACD9FB45C for ; Tue, 18 Jul 2006 12:21:47 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x37so85708nfc for ; Tue, 18 Jul 2006 08:21:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=ooLWj5HlxY7QNFkrOgEKJHGt80b3MdbaxWcHWKghst5Q2eCV5CMnRBq/rmdhohTh9qfhfH0VG2eK7spJ4Zn6kVBOqShh7/b4ugkrcTw9maO0Bv6Q/Vp2jj4qCg/EXsF98gWT9DyX6TwYLMTaVKfrIzjO0R/4zEanHLWF2Q86GC8= Received: by 10.78.120.6 with SMTP id s6mr1458898huc; Tue, 18 Jul 2006 08:21:45 -0700 (PDT) Received: by 10.78.32.10 with HTTP; Tue, 18 Jul 2006 08:21:45 -0700 (PDT) Message-ID: Date: Tue, 18 Jul 2006 10:21:45 -0500 From: "Aaron Bono" To: adey Subject: Re: Tables not restored from V7.4 to v8.1.4 Cc: "pgsql-admin@postgresql.org" , postgresql-l In-Reply-To: <1c66bda80607171750j49b271cfvdd88b61c7252aa88@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_26670_15264715.1153236105565" References: <1c66bda80607171750j49b271cfvdd88b61c7252aa88@mail.gmail.com> X-Google-Sender-Auth: 5914bd0bfec03b08 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/153 X-Sequence-Number: 22399 ------=_Part_26670_15264715.1153236105565 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_26670_15264715.1153236105565 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_26670_15264715.1153236105565--