Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version

I only did the plain text as it was a suggested test. I still have the situation that the same version of pgadmin makes a back up on a win 7 64 bit machine can not be restored using a win xp system. It gets the unsupported version error for some unknown reason. Both systems used the same msi file to install pgadmin and I double checked that pg_dump.exe and pg_restore.exe are the same versions on both machines.
________________________________
From: Guillaume Lelarge [guillaume(at)lelarge(dot)info]
Sent: Tuesday, June 30, 2015 1:22 AM
To: Ron Gregor
Cc: pgadmin-support(at)postgresql(dot)org; rod(at)iol(dot)ie
Subject: Re: [pgadmin-support] Retore database on win xp from back up created with win 7 64 bit gets unsupported version

Le 29 juin 2015 11:25 PM, "Ron Gregor" <RGregor(at)wcnjcd(dot)com<mailto:RGregor(at)wcnjcd(dot)com>> a écrit :
>
> 32/64 bit problem - That is what I am trying to find out if there is a problem with running the on 32 bit versus 64 bit machines. I did not find any place to download a windows 64 bit version.
>
> I created a backup using the PLAIN option (closes to text option available) which created a sql file. When I tried to restore this file pgadmin gave me an error "input file does not appear to be a valid archive".
>

That has nothing to do with 32 vs 64 bits. PgAdmin uses pg_restore to restore a backup, and pg_restore knows nothing about plain backup. It can only work with binary backup (ie tar, custom, or directory).

You'll have to do a backup again, this time in one of the binary formats. Or use psql to restore your backup.