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 7A5B8D1C4C1 for ; Tue, 22 Jul 2003 21:09:33 +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-09 for ; Tue, 22 Jul 2003 18:08:48 -0300 (ADT) Received: from mail.gmx.net (pop.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 9E24DD1C4E6 for ; Tue, 22 Jul 2003 18:09:30 -0300 (ADT) Received: (qmail 12471 invoked by uid 65534); 22 Jul 2003 21:09:32 -0000 Received: from unknown (EHLO guaj215desa) (168.234.68.69) by mail.gmx.net (mp001) with SMTP; 22 Jul 2003 23:09:32 +0200 MIME-Version: 1.0 Message-Id: <3F1DA7CF.000001.02764@guaj215desa> Date: Tue, 22 Jul 2003 15:08:31 -0600 Content-Type: Multipart/related; type="multipart/alternative"; boundary="------------Boundary-00=_7Q2GQL80000000000000" X-Mailer: IncrediMail 2001 (1850912) From: "Marvin" References: X-FID: FLAVOR00-NONE-0000-0000-000000000000 X-FVER: X-CNT: ; X-Priority: 3 To: Cc: Subject: Re: pg_restore problem!!! Reply-To: "Marvin" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=3.3 tagged_above=0.0 required=5.0 tests=ASCII_FORM_ENTRY, EXTRA_MPART_TYPE, HTML_30_40, HTML_FONT_COLOR_BLUE, HTML_FONT_FACE_ODD, HTML_MESSAGE, HTML_TAG_EXISTS_TBODY, PLING_PLING, QUOTED_EMAIL_TEXT, REFERENCES X-Spam-Level: *** X-Archive-Number: 200307/222 X-Sequence-Number: 9562 --------------Boundary-00=_7Q2GQL80000000000000 Content-Type: Multipart/Alternative; boundary="------------Boundary-00=_7Q2GLVC0000000000000" --------------Boundary-00=_7Q2GLVC0000000000000 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you.=0D You saved my day!!!=0D That command restores all my data into my DB.=0D =0D MAGO=0D =0D -------Mensaje original-------=0D =0D De: David Olbersen=0D Fecha: Martes, 22 de Julio de 2003 03:02:48 p.m.=0D A: pgsql-admin@postgresql.org=0D Asunto: Re: [ADMIN] pg_restore problem!!!=0D =0D Nick,=0D =0D > To restore from a plain-text dump file, just pipe it into =0D > psql like so:=0D > =0D > cat [filename] | psql [dbname]=0D =0D To nit-pick, this is a "useless use of cat".=0D =0D In UNIX-land, simple input redirection will work much better:=0D =0D psql [dbname and various options] < [filename]=0D =0D It's also less to type! :)=0D =0D I also believe this works in certain Windows operating systems, which is what it appears Mago is using.=0D =0D --------------------------=0D David Olbersen =0D iGuard Engineer=0D St. Bernard Software=0D 11415 West Bernardo Court =0D San Diego, CA 92127 =0D 1-858-676-2277 x2152=0D =0D =0D > -----Original Message-----=0D > From: Nick Fankhauser [mailto:nickf@ontko.com]=0D > Sent: Tuesday, July 22, 2003 1:30 PM=0D > To: Marvin; pgsql-admin@postgresql.org=0D > Subject: Re: [ADMIN] pg_restore problem!!!=0D > =0D > =0D > Mago-=0D > =0D > pg_restore is used to restore a dump file created in one of =0D > the non-text=0D > formats such as tar format.=0D > =0D > To restore from a plain-text dump file, just pipe it into =0D > psql like so:=0D > =0D > cat [filename] | psql [dbname]=0D > =0D > -Nick=0D > =0D > ---------------------------------------------------------------------=0D > Nick Fankhauser=0D > =0D > nickf@doxpop.com Phone 1.765.965.7363 Fax 1.765.962.9788=0D > doxpop - Court records at your fingertips - http://www.doxpop.com/=0D > -----Original Message-----=0D > From: pgsql-admin-owner@postgresql.org=0D > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Marvin=0D > Sent: Tuesday, July 22, 2003 3:22 PM=0D > To: pgsql-admin@postgresql.org=0D > Subject: [ADMIN] pg_restore problem!!!=0D > =0D > =0D > 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=0D > insert every piece of data and reconstruct my schema. However =0D > when I try to=0D > 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 =0D > valid archive=0D > =0D > What I am doing wrong??=0D > Any ideas??=0D > =0D > Thank you in advanced.=0D > =0D > =0D > MAGO=0D > =0D > =0D > _________________________________________________________________=0D > IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aqu=ED=0D > =0D > =0D > ---------------------------(end of =0D > broadcast)---------------------------=0D > TIP 8: explain analyze is your friend=0D > =0D =0D ---------------------------(end of broadcast)---------------------------=0D TIP 4: Don't 'kill -9' the postmaster=0D =0D =2E --------------Boundary-00=_7Q2GLVC0000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you.
You saved my day!!!
That command restores all my data into my DB.
 
MAGO
 
-------Mensaje original-------
 
Fecha: Martes, 22 de= Julio de 2003 03:02:48 p.m.
Asunto: Re: [ADMIN] = pg_restore problem!!!
 
Nick,

> To restore from a plain-text dump file, = just pipe it into
> psql like so:
>
> cat [filename] | = psql [dbname]

To nit-pick, this is a "useless use of cat".

In= UNIX-land, simple input redirection will work much better:

psql [db= name and various options] < [filename]

It's also less to type! :)=

I also believe this works in certain Windows operating systems, whi= ch is what it appears Mago is using.

--------------------------
D= avid Olbersen
iGuard Engineer
St. Bernard Software
11415 West Ber= nardo Court
San Diego, CA 92127
1-858-676-2277 x2152


>= ; -----Original Message-----
> From: Nick Fankhauser [mailto:nickf@ontko.com]
> Sent: Tuesday, July= 22, 2003 1:30 PM
> To: Marvin; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] pg_res= tore problem!!!
>
>
> 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-t= ext dump file, just pipe it into
> psql like so:
>
> ca= t [filename] | psql [dbname]
>
> -Nick
>
> ------= ---------------------------------------------------------------
> Nic= k Fankhauser
>
> nickf@dox= pop.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<= /A>
> [
mailto:pgs= ql-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 p= roblem!!!
>
>
> I made a back up file with this sentenc= e:
>
> pg_dump -U [superusername] -C -D -f [filename] [dbname]=
>
> It seems to work fine. I opened the file and I saw all th= e commands to
> insert every piece of data and reconstruct my schema.= However
> when I try to
> restore that file it gets me the fo= llowing error:
>
> C:\>pg_restore [filename]
> pg_res= tore: [archiver] input file does not appear to be a
> valid archive<= BR>>
> What I am doing wrong??
> Any ideas??
>
&g= t; Thank you in advanced.
>
>
> MAGO
>
> <= BR>> _________________________________________________________________> IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aqu= =ED
>
>
> ---------------------------(end of
> b= roadcast)---------------------------
> TIP 8: explain analyze is your= friend
>

---------------------------(end of broadcast)------= ---------------------
TIP 4: Don't 'kill -9' the postmaster

.
____________________________= _____________________________________
3D""  IncrediMail - El E-m= ail ha evolucionado finalmente - Haga clic aqu=ED
--------------Boundary-00=_7Q2GLVC0000000000000-- --------------Boundary-00=_7Q2GQL80000000000000 Content-Type: image/gif; name="IMSTP.gif" Content-Transfer-Encoding: base64 Content-ID: <52AF1FE1-55FD-4D63-AFD5-803DCB01F833> 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=_7Q2GQL80000000000000--