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 f5SIBwa68100 for ; Thu, 28 Jun 2001 14:11:58 -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 LAA08471 for ; Thu, 28 Jun 2001 11:11:09 -0700 Message-ID: <3B3B73AD.EEB7DAEE@commandprompt.com> Date: Thu, 28 Jun 2001 11:13:01 -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: pgsql sql Subject: restoring a dump Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/456 X-Sequence-Number: 3759 Hello, I have been trying to restore my dump and it seems like it is not working. I put the dump in a tar file and when I untarred it, there are several .dat files, a toc.dat file, and a restore.sql file. I used psql to restore these files into a database. I first started restoring the restore.sql file, then the .dat files, and lastly, the toc.dat. When I did the toc.dat file, I received an error message. These are the 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 This is the error message: ERROR: parser: parse error at or near "pgdmp" CHANGE ERROR: non-existent group "test" ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ ERROR: parser: parse error at or near """ I also tried using the pg_restore, but I don't know how that would work on these separate files. Is there another way I can restore the dump? Maybe an easier way than what I have been using? And do I need to restore what is in the toc.dat? Thank you for your help.