Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2010
    Posts
    5

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

    Hello friends,

    I am Kranthi here..

    I am using PostgreSQL version 1.8.4 (Nov 6 200, rev 7358)

    Up to now i worked on Windows XP env.

    I wanted to migrate to Linux (Ubuntu v 9.04).

    So, on Ubuntu i have installed Postgresql of same version 1.8.4. And, i tried to restore the data what i have taken (backup) in windows env.

    When i am trying to restore using PGADMIN III, I am getting the error like this: "pg_restore: [archiver] unsupported version (1.11) in file header postgresql"

    So, can any one of you tell me the procedure to take backup.

    I am looking for ur reply......

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    There is no Postgres version 1.8.4, do you mean 8.4.1?

    How exactly did you take the backup on your Windows box (what was the exact command you used?

  3. #3
    Join Date
    Feb 2010
    Posts
    5
    Sorry...!!

    What i mean is PGADMIN 1.8.4

    I have taken backup on WIndows System using same version.

    Here in linux (ubuntu 9.10) also i am using the same version.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by kranthipoturaju View Post
    I have taken backup on WIndows System using same version.

    Here in linux (ubuntu 9.10) also i am using the same version.
    How did you take the backup? what were the parameters you passed to pg_dump (or pg_dumpall)

  5. #5
    Join Date
    Feb 2010
    Posts
    5
    Using PGADMIN 3:

    PGADMIN will provide one functionality Backup.....
    I have taken backup with that tool. Not with command (pg_dump).

    And, it is providing one more tool restore..
    But, the restore is returning error.

  6. #6
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Did you have a look at the export file? Is that a plain text (SQL) file or a binary file?

    If it is plain text you simply run the SQL script. I don't know PGAdmin, but it seems that the restore feature assumes a binary file.

  7. #7
    Join Date
    Feb 2010
    Posts
    5
    i am having only *.backup file....

  8. #8
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    And is that plain text or binary?

  9. #9
    Join Date
    Feb 2010
    Posts
    5
    binary........

  10. #10
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Then you'll need to use pg_restore. I have no idea where this is hidden in the pgAdmin menus.

    Try to restore it using pg_restore, and see if you still get the same error

    PostgreSQL: Documentation: Manuals: PostgreSQL 8.4: pg_restore

    If you get the same error, then there is something wrong with your backup and you should take a new backup from your source (using the commandline tools rather than pgAdmin)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •