Skip site navigation (1) Skip section navigation (2)


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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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 ?


Relax. Yahoo! Mail virus scanning helps detect nasty viruses!


pgsql-novice by date

Next:From: Tom LaneDate: 2006-03-03 00:23:01
Subject: Re: [NOVICE] pg_config --pgxs
Previous:From: George WeaverDate: 2006-03-02 23:32:31
Subject: Re: pg_config --pgxs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group