Received: from commandprompt.com (dsl081-185-190.sea1.dsl.speakeasy.net [64.81.185.190]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5SNVla91838 for ; Thu, 28 Jun 2001 19:31:47 -0400 (EDT) (envelope-from pma@commandprompt.com) Received: from commandprompt.com (filesrv.commandprompt.com [192.168.1.35]) by commandprompt.com (8.9.3/8.9.3) with ESMTP id QAA13560; Thu, 28 Jun 2001 16:30:54 -0700 Message-ID: <3B3BBE9F.48D125F5@commandprompt.com> Date: Thu, 28 Jun 2001 16:32:47 -0700 From: Phuong Ma X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.3-20mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: Peter Eisentraut CC: pgsql sql Subject: Re: restoring a dump References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/461 X-Sequence-Number: 3764 Peter Eisentraut wrote: > > Phuong Ma writes: > > > pg_dump -C -D -F t > test.tar > > tar -xvf test.tar > > psql restore.sql > > psql test < 19.dat > > psql test < 20.dat .. and so on > > psql test < toc.dat > > I believe you're supposed to use pg_restore on the tar file itself. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter I tried using pg_restore, but it did not restore the dump successfully. Maybe it is the syntax I'm using, but I remember reading that you cannot use the pg_restore to restore a dump that uses INSERT. Does anyone know of a way I could undump my db?