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 [guilla...@lelarge.info] Sent: Tuesday, June 30, 2015 1:22 AM To: Ron Gregor Cc: pgadmin-support@postgresql.org; r...@iol.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" <rgre...@wcnjcd.com<mailto:rgre...@wcnjcd.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.
