Re: Restore xxxxx.backup database - Mailing list pgsql-general

From Tom Lane
Subject Re: Restore xxxxx.backup database
Date
Msg-id 11074.1127828884@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restore xxxxx.backup database  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> adccs wrote:
>> [root@adccs ~]# /usr/bin/pg_restore -a /tmp/royapuram.backup
>> ERROR: pg_restore: [archiver] unsupported version (1.10) in file header

> Your user probably has a more recent version of PostgreSQL than you do,
> so pg_restore can't understand the format of the backup file.

Looking at the code, 1.10 corresponds to PG 8.0.  A pg_restore version
older than 8.0 can't handle it because it won't know what to do with the
fields for tables' tablespaces.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extraordinarily slow!!
Next
From: Tom Lane
Date:
Subject: Re: Mysterious query plan