Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5580C9FB571 for ; Tue, 19 Jun 2007 12:18:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 60597-01 for ; Tue, 19 Jun 2007 12:18:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from silene.metacarta.com (silene.metacarta.com [65.77.47.18]) by postgresql.org (Postfix) with ESMTP id D49D79FB660 for ; Tue, 19 Jun 2007 12:18:46 -0300 (ADT) Received: from localhost (silene.metacarta.com [65.77.47.18]) by silene.metacarta.com (Postfix) with ESMTP id 5CD5214C8BB4 for ; Tue, 19 Jun 2007 11:18:45 -0400 (EDT) Received: from silene.metacarta.com ([65.77.47.18]) by localhost (silene.metacarta.com [65.77.47.18]) (amavisd-new, port 10024) with ESMTP id 19314-08 for ; Tue, 19 Jun 2007 11:18:43 -0400 (EDT) X-Auth-Received: from [65.77.47.195] (dhcp-65-77-47-195.metacarta.com [65.77.47.195]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by silene.metacarta.com (Postfix) with ESMTP id AFA5B14C8BB3 for ; Tue, 19 Jun 2007 11:18:43 -0400 (EDT) Message-ID: <4677F3D2.6050909@metacarta.com> Date: Tue, 19 Jun 2007 11:18:42 -0400 From: Karl Wright User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Export/import issue/question Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at metacarta.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/174 X-Sequence-Number: 25842 Hi, I'm trying to move a database from postgresql 7.4 to postgresql 8.1. Unfortunately this is not going well. This is what I did: pg_dump --file dbsnapshot --format=t -a -b and then I installed 8.1, and attempted the following: pg_restore --file dbsnapshot --format=t --table=ingeststatus -a But, I get the following error: pg_restore: [tar archiver] could not find header for file toc.dat in tar archive However, a tar tf shows that toc.dat is indeed in the dbsnapshot file: kwright@baetis:/common$ tar tf dbsnapshot toc.dat 2.dat 3.dat 4.dat 5.dat 6.dat 7.dat 8.dat 9.dat 10.dat 11.dat 12.dat 13.dat 14.dat 15.dat ... The tar is pretty large: -rw-r--r-- 1 root root 6892524032 Jun 19 09:48 dbsnapshot Any idea what I'm doing wrong? Karl