Re: How to recover data from 9.3 data directory

Le sam. 13 mars 2021 à 22:02, Andrus <kobruleht2(at)hot(dot)ee> a écrit :

> Hi!
>
> > that won't work on windows. pg_upgrade only works if source and target
> environment are binary compatible, which isn't the case for windows / GNU
> Linux.
>
> wal archiving works between Linux and Windows. So I expected those
> commands to work also.
>

WAL archiving is only a file copy, you can copy them anywhere without
restrictions on the architecture.

> How to determine is this data from 32 or 64 bit server ?
>
it's not really a question of the binary pointer size but the target
hardware specificity.

> Should I create virtual machine and install Linux with 9.3 into it or is
> there simpler solution?
>
that's the only option, unless you already have some compatible server
around.

> Will data from 32 bit server require 32 bit Linux with 32 bit postgres or
> will it work with 64 bit Linux also ?
>
I think that it won't matter and a 64 bits server will work just fine, but
only testing will give a definite answer.

>