Thread: Restore xxxxx.backup database

Help needed to restore a backup database!

1. Postgres service was started. When I run a restore command for the backup stored in /tmp (backed from another server working on this database and sent to meby email by another user). I created a database by the same name "royapuram" by using createdb in template1 and then ran the following command:

[root@adccs ~]# /usr/bin/pg_restore -a /tmp/royapuram.backup
ERROR: pg_restore: [archiver] unsupported version (1.10) in file header

2. Alternatively I used (after creating "royapuram" database
[root@adccs ~]# su - postgres
-bash-3.00$ psql royapuram  < /tmp/royapuram.backup;
RESULT
ERROR:  syntax error at or near "
" at character 1
and the whole terminal churns up junk characters and stops!

What  do I do to restore!!
Regards

K. Rajaraman

adccs wrote:
> Help needed to restore a backup database!
>
> 1. Postgres service was started. When I run a restore command for the
> backup stored in /tmp (backed from another server working on this
> database and sent to meby email by another user). I created a database
> by the same name "royapuram" by using createdb in template1 and then ran
> the following command:
>
> [root@adccs ~]# /usr/bin/pg_restore -a /tmp/royapuram.backup
> ERROR: pg_restore: [archiver] unsupported version (1.10) in file header

Do the versions for the two installations of PostgreSQL match? (Hint - I
think the answer will be "no").

> 2. Alternatively I used (after creating "royapuram" database
> [root@adccs ~]# su - postgres
> -bash-3.00$ psql royapuram  < /tmp/royapuram.backup;
> RESULT
> ERROR:  syntax error at or near "
" at character 1
> and the whole terminal churns up junk characters and stops!

You can only do this with a text dump. The file you have is probably in
the "compressed" format.

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.

--
   Richard Huxton
   Archonet Ltd

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