pg_restore

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: Raw Message | Whole Thread | 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!

Responses

Browse pgsql-novice by date

  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