postgres restore

[Paul Mulroney]

Hi Kim,

Strangely enough, this happened to us today too! Turns out we had different versions of Postgres - 9.4.1 vs 9.4.13(?).  Same error message.

You should have the exact same version of Postgres on each machine.

Regards,
Paul.


> On 28 Aug 2018, at 8:07 pm, David Blaymires via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi Kim
> 
> It will be the version in the other computer is an older one. We’ve had this as well. They changed something in the way that pgdump creates the backup file, update the older version to the same as the Windows 10 version. 
> 
> Regards,
> David Blaymires
> 
>> On 28 Aug 2018, at 9:45 pm, Kim martel <kim at martel.com.au> wrote:
>> 
>> I have installed a new computer running Win10 and postgres 9.5.  Running OS 8.0
>> 
>> 
>> 
>> When I backup a postgres file (9.5) all seems ok.
>> 
>> 
>> 
>> 1.       It will restore with pg Admin111 on the same computer
>> 
>> 2.       When I try to restore it on an older computer or laptop running Win 7 and postgres 9.5  it comes up with error code 1.    (unsupported version (1.13) in the header).
>> 
>> 
>> 
>> If I restore a Win7 backup on the Win 10 machine it works ok
>> 
>> 
>> 
>> Is there a difference on how a Win 10 does the backup or puts information in the header.
>> 
>> 


"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
C.A.R. Hoare
-- 
Paul W. Mulroney                           We Don't Do Simple Pty Ltd 
pmulroney at logicaldevelopments.com.au       Trading as Logical Developments
www.logicaldevelopments.com.au             ACN 161 009 374 
Ph: +61 8 9458 3889                        86 Coolgardie Street
                                           BENTLEY  WA  6102