From: | "David Olbersen" <DOlbersen(at)stbernard(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_restore problem!!! |
Date: | 2003-07-22 20:54:09 |
Message-ID: | E7E213858379814A9AE48CA6754F5ECB0D7005@mail01.stbernard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 [dbname and various options] < [filename]
It's also less to type! :)
I also believe this works in certain Windows operating systems, which is what it appears Mago is using.
--------------------------
David Olbersen
iGuard Engineer
St. Bernard Software
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152
> -----Original Message-----
> From: Nick Fankhauser [mailto:nickf(at)ontko(dot)com]
> Sent: Tuesday, July 22, 2003 1:30 PM
> To: Marvin; pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] pg_restore 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-text dump file, just pipe it into
> psql like so:
>
> cat [filename] | psql [dbname]
>
> -Nick
>
> ---------------------------------------------------------------------
> Nick Fankhauser
>
> nickf(at)doxpop(dot)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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Marvin
> Sent: Tuesday, July 22, 2003 3:22 PM
> To: pgsql-admin(at)postgresql(dot)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í
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-07-22 20:56:34 | Re: How can I set a default schema for a session |
Previous Message | Dilan Arumainathan | 2003-07-22 20:52:22 | How can I set a default schema for a session |