| From: | Marco Rossi <swmrrossi(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | pg_restore |
| Date: | 2006-03-02 23:52:19 |
| Message-ID: | 20060302235219.32422.qmail@web80907.mail.scd.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
I'm trying to import a db from one server to my local machine.
I have a mismatch betweek server pg_dump (8.0.3) and my machine pg_restore vesion (7.4.7).
Reading the docs I found that -i option should be used to ignore conflicts betweek dump version and db server .
So i issued a
pg_restore -i -C -d 20 -Fc -v < 20.sql
where 20.sql is the dump generated on the server with
pg_dump -Fc -C -d f /tmp/20.sql db-gw-20
and 20 (-d parameter) is a new db created as createdb 20 on the cmd line.
I receive a "pg_restore: [archiver] unsupported version in file header" error message.
Does anybody know if there is a work around for this ?
Thanks,
Marco
---------------------------------
Relax. Yahoo! Mail virus scanning helps detect nasty viruses!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-03 00:23:01 | Re: [NOVICE] pg_config --pgxs |
| Previous Message | George Weaver | 2006-03-02 23:32:31 | Re: pg_config --pgxs |