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......

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?

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.

How did you take the backup? what were the parameters you passed to pg_dump (or pg_dumpall)

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.

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.

i am having only *.backup file....

And is that plain text or binary?

binary........

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)