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 347829F95E3 for ; Mon, 17 Jul 2006 21:50:55 -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 73773-05 for ; Tue, 18 Jul 2006 00:50:48 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id D57F29F94F3 for ; Mon, 17 Jul 2006 21:50:48 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so1995506ugc for ; Mon, 17 Jul 2006 17:50:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=dKx/WUuGbx6rFGVGIX7zEO6L9JF9HR+KLVZVkSZ/KuMlVToIqBx6YPUwZUow3YHFTnMhwZTdft6AXXVlgUbebS6I6IwObdyOVm5wv+g+ToUki/47VARrLjPWDFIqUEY6i/99LqqWLFOw91MtqhcMFH4uC73337jwXrzYTHvV0mc= Received: by 10.67.22.2 with SMTP id z2mr3029800ugi; Mon, 17 Jul 2006 17:50:44 -0700 (PDT) Received: by 10.66.241.4 with HTTP; Mon, 17 Jul 2006 17:50:44 -0700 (PDT) Message-ID: <1c66bda80607171750j49b271cfvdd88b61c7252aa88@mail.gmail.com> Date: Tue, 18 Jul 2006 12:50:44 +1200 From: adey To: "pgsql-admin@postgresql.org" , postgresql-l Subject: Tables not restored from V7.4 to v8.1.4 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_91857_29888518.1153183844507" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/149 X-Sequence-Number: 22395 ------=_Part_91857_29888518.1153183844507 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? ------=_Part_91857_29888518.1153183844507 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? ------=_Part_91857_29888518.1153183844507--