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

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

Thanks, Ron

________________________________________
From: Raymond O'Donnell [rod(at)iol(dot)ie]
Sent: Monday, June 29, 2015 12:22 PM
To: Ron Gregor; pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Retore database on win xp from back up created with win 7 64 bit gets unsupported version

On 29/06/2015 16:51, Ron Gregor wrote:
> I have pgadmin 1.10.0 installed on 2 machines. One is win xp and one is
> win 7 64 bit. I even checked that the rev numbers are the same. The back
> up was created using the win 7 64 machine (both using gui and batch
> file). When I try to use the win xp machine to restore the database I
> get the "unsupported version (1.11) in file header" error. Restoring
> using the win 7 64 machine works regardless of which machine creates the
> back up.
>
> pg_dump.exe and pg_restore.exe are the same versions on both machines
> (8.4.0.9177).
>
> Is there a difference in the back up file if win 7 64 creates it versus
> win xp creating it?

Only guessing here, but could it be a 32/64-bit problem?

You could also try using the text format for the backup, if your
database isn't too big - that's bound to work.

HTH,

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie