| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Ron Gregor <RGregor(at)wcnjcd(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org, "rod(at)iol(dot)ie" <rod(at)iol(dot)ie> |
| Subject: | Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version |
| Date: | 2015-06-30 05:22:24 |
| Message-ID: | CAECtzeW7L6iqMqYN_SpYOYEJbTehCaV4+MkO43Db7N-UxR1YHQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Le 29 juin 2015 11:25 PM, "Ron Gregor" <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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benoît ROLLAND | 2015-06-30 10:03:49 | plugins not installed in any version of pgadmin installed |
| Previous 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 |