Richard Huxton <dev(at)archonet(dot)com> writes:
> adccs wrote:
>> [root(at)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