Richard Huxton <dev@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend