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 05461D1C4C1 for ; Tue, 22 Jul 2003 20:22:36 +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 89653-04 for ; Tue, 22 Jul 2003 17:21:51 -0300 (ADT) Received: from mail.gmx.net (pop.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 7E464D1C4F1 for ; Tue, 22 Jul 2003 17:22:33 -0300 (ADT) Received: (qmail 19773 invoked by uid 65534); 22 Jul 2003 20:22:34 -0000 Received: from unknown (EHLO guaj215desa) (168.234.68.69) by mail.gmx.net (mp023) with SMTP; 22 Jul 2003 22:22:34 +0200 MIME-Version: 1.0 Message-Id: <3F1D9CCC.000003.02764@guaj215desa> Date: Tue, 22 Jul 2003 14:21:32 -0600 Content-Type: Multipart/related; type="multipart/alternative"; boundary="------------Boundary-00=_WJ0GG6G0000000000000" X-Mailer: IncrediMail 2001 (1850912) From: "Marvin" X-FID: FLAVOR00-NONE-0000-0000-000000000000 X-FVER: 3.0 X-CNT: ; X-Priority: 3 To: Subject: pg_restore problem!!! Reply-To: "Marvin" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=3.9 tagged_above=0.0 required=5.0 tests=ASCII_FORM_ENTRY, EXTRA_MPART_TYPE, HTML_50_60, HTML_FONT_COLOR_BLUE, HTML_FONT_FACE_ODD, HTML_MESSAGE, HTML_TAG_EXISTS_TBODY, PLING_PLING X-Spam-Level: *** X-Archive-Number: 200307/218 X-Sequence-Number: 9558 --------------Boundary-00=_WJ0GG6G0000000000000 Content-Type: Multipart/Alternative; boundary="------------Boundary-00=_XJ0GBHK0000000000000" --------------Boundary-00=_XJ0GBHK0000000000000 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I made a back up file with this sentence:=0D =0D pg_dump -U [superusername] -C -D -f [filename] [dbname]=0D =0D 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:=0D =0D C:\>pg_restore [filename]=0D pg_restore: [archiver] input file does not appear to be a valid archive=0D =0D What I am doing wrong??=0D Any ideas??=0D =0D Thank you in advanced.=0D =0D =0D MAGO --------------Boundary-00=_XJ0GBHK0000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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 t= o 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 archiv= e
 
What I am doing wrong??
Any ideas??
 
Thank you in advanced.
 
 
MAGO
____________________________= _____________________________________
3D""  IncrediMail - El E-m= ail ha evolucionado finalmente - Haga clic aqu=ED
--------------Boundary-00=_XJ0GBHK0000000000000-- --------------Boundary-00=_WJ0GG6G0000000000000 Content-Type: image/gif; name="IMSTP.gif" Content-Transfer-Encoding: base64 Content-ID: <5BACF5D4-FA8A-4CC1-AEBF-63B97DC46745> R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAA AAAAAAAAAAAAAAAAAAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQJFAAIACwA AAAAFAAPAAAEVRDJSaudJuudrxlEKI6BURlCUYyjKpgYAKSgOBSCDEuGDKgr AtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRtE30tVVRscMHD qV/u+AgAIfkEBWQACAAsAAAAABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQA IfkECRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCq K1kS9grQhXGAhsDBUJgZAL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKX dAgRAQAh+QQFCgAIACwAAAAAFAAPAAAEEhDJSau9OOvNu/9gKI5kaZ5oBAAh +QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj1g2FsKor WRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0 CBEBACH5BAVkAAgALAAAAAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --------------Boundary-00=_WJ0GG6G0000000000000--