http://forums.enterprisedb.com/posts/list/9.page JForum - http://www.jforum.net
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


]]> http://forums.enterprisedb.com/posts/preList/2112/7870.page http://forums.enterprisedb.com/posts/preList/2112/7870.page GMT 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).]]> http://forums.enterprisedb.com/posts/preList/2112/7872.page http://forums.enterprisedb.com/posts/preList/2112/7872.page GMT 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]]> http://forums.enterprisedb.com/posts/preList/2112/7873.page http://forums.enterprisedb.com/posts/preList/2112/7873.page GMT 8.3.6 [/quote]

Please try with pg_restore of 8.4.]]> http://forums.enterprisedb.com/posts/preList/2112/7874.page http://forums.enterprisedb.com/posts/preList/2112/7874.page GMT http://forums.enterprisedb.com/posts/preList/2112/8024.page http://forums.enterprisedb.com/posts/preList/2112/8024.page GMT 8.3.6 [/quote]

Please try with pg_restore of 8.4.[/quote]

I had same problem and i could fix it using pg_restore of 8.4.
Thanks a lot!]]> http://forums.enterprisedb.com/posts/preList/2112/8889.page http://forums.enterprisedb.com/posts/preList/2112/8889.page GMT