pg_restore: [archiver] unsupported version (1.11) in file header

Hi

I am using postgres 8.3. I wanna perform DB restore on db dump created on version 8.4 .

I am getting error: pg_restore: [archiver] unsupported version (1.11) in file header
Can any one help me how to handle this version conflict.

Restore using command line with -i option also doesn't help.

Awaiting reply.

Thanks in advance.

Yogesh

This message was edited 1 time. Last update was at 09/01/2010 03:36:07

Please provide following information:
1. Command which you are using to take backup.
2. Command which you are using for Restore.
3. Version of pg_dump (i.e pg_dump --version).
4. Version of pg_restore(i.e pg_restore --version).

This message was edited 3 times. Last update was at 09/01/2010 04:05:18

Thanks for the reply...
Here is the info which u needed.

1. Command which you are using to take backup. =>
C:\Program Files\PostgreSQL\8.3\bin\pg_dump.exe -U postgres -F c -v -f "C:\Documents and Settings\yogesh_naik\Desktop\Backup_Profiler_Structure.backup" -n \"public\" "replica"

2. Command which you are using for Restore. =>
"c:\program files\PostgreSQL\8.3\bin\pg_restore.exe" -U postgres -d replica -i -F c -v E:\Backup_Profiler_Structure.backup

3. Version of pg_dump (i.e pg_dump --version).
8.4.2
4. Version of pg_restore(i.e pg_restore --version).
8.3.6

4. Version of pg_restore(i.e pg_restore --version).
8.3.6

Please try with pg_restore of 8.4.

Is there any way to change the backup file or command so that the 8.4 backup file can be restored on 8.3 postgres db?

Vibhor_K wrote:

4. Version of pg_restore(i.e pg_restore --version).
8.3.6

Please try with pg_restore of 8.4.

I had same problem and i could fix it using pg_restore of 8.4.
Thanks a lot!