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 [r...@iol.ie] Sent: Monday, June 29, 2015 12:22 PM To: Ron Gregor; pgadmin-support@postgresql.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 r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
