X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A0D2FD1C4E6 for ; Tue, 22 Jul 2003 20:31:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 89701-05 for ; Tue, 22 Jul 2003 17:30:25 -0300 (ADT) Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by svr1.postgresql.org (Postfix) with ESMTP id A8BC6D1C4DC for ; Tue, 22 Jul 2003 17:31:08 -0300 (ADT) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.12.3/8.12.3/Debian-6.4) with SMTP id h6MKV20P012932; Tue, 22 Jul 2003 15:31:02 -0500 Reply-To: From: "Nick Fankhauser" To: "Marvin" , Subject: Re: pg_restore problem!!! Date: Tue, 22 Jul 2003 15:29:33 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <3F1D9CCC.000003.02764@guaj215desa> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=IN_REP_TO, MSGID_GOOD_EXCHANGE, ORIGINAL_MESSAGE, PLING_PLING X-Spam-Level: X-Archive-Number: 200307/219 X-Sequence-Number: 9559 Mago- pg_restore is used to restore a dump file created in one of the non-text formats such as tar format. To restore from a plain-text dump file, just pipe it into psql like so: cat [filename] | psql [dbname] -Nick --------------------------------------------------------------------- Nick Fankhauser nickf@doxpop.com Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your fingertips - http://www.doxpop.com/ -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Marvin Sent: Tuesday, July 22, 2003 3:22 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] pg_restore problem!!! I made a back up file with this sentence: pg_dump -U [superusername] -C -D -f [filename] [dbname] It seems to work fine. I opened the file and I saw all the commands to insert every piece of data and reconstruct my schema. However when I try to restore that file it gets me the following error: C:\>pg_restore [filename] pg_restore: [archiver] input file does not appear to be a valid archive What I am doing wrong?? Any ideas?? Thank you in advanced. MAGO _________________________________________________________________ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí