Re: Data migration from version 7.2.1 to 8.1.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arindam <arindam(dot)mukerjee(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data migration from version 7.2.1 to 8.1.5
Date: 2007-02-08 15:44:56
Message-ID: 8271.1170949496@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arindam <arindam(dot)mukerjee(at)gmail(dot)com> writes:
> I tried dumping data in tar format using the pg_dump utility (with
> version 7.2.1) and restoring it using pg_restore utility (with version
> 8.1.5). But on running this command:

> pg_restore -d mydb -C -u <my_dump_file>
> I get the following error:
> pg_restore: [archiver] unsupported version (1.10) in file header

It looks to me a whole lot like you got it backward, ie, used the 8.1
pg_dump and then tried to restore with the 7.2 pg_restore.

Now you *should* be using the newer pg_dump to dump from the old
database --- that's considered good practice. But you need an
up-to-date pg_restore to read its output.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2007-02-08 15:52:22 [Security] New RPM Sets for Fedora Core / Red Hat Enterprise Linux
Previous Message Arindam 2007-02-08 15:31:49 Data migration from version 7.2.1 to 8.1.5