Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version
| От | Ron Gregor |
|---|---|
| Тема | Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version |
| Дата | |
| Msg-id | 18880A3237CA944F93E5DB05DD824D64322D85F9@WCNSERVER.wcn.local обсуждение исходный текст |
| Ответ на | Re: Retore database on win xp from back up created with win 7 64 bit gets unsupported version (Guillaume Lelarge <guillaume@lelarge.info>) |
| Ответы |
Re: Retore database on win xp from back up created
with win 7 64 bit gets unsupported version
|
| Список | pgadmin-support |
Sent: Tuesday, June 30, 2015 1:22 AM
To: Ron Gregor
Cc: pgadmin-support@postgresql.org; rod@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" <RGregor@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.
В списке pgadmin-support по дате отправления: