From: | Ron Gregor <RGregor(at)wcnjcd(dot)com> |
---|---|
To: | "rod(at)iol(dot)ie" <rod(at)iol(dot)ie>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version |
Date: | 2015-06-29 17:11:46 |
Message-ID: | 18880A3237CA944F93E5DB05DD824D64322D72C9@WCNSERVER.wcn.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2015-06-29 18:26:07 | Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version |
Previous Message | Raymond O'Donnell | 2015-06-29 16:22:20 | Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version |