Thread: recovery of a windows archive in linux

Dear list,

I have a base backup and archive logs from a Windows 7 PGSQL 9.3 install. The machine OS disk started to show signs of failure so I replaced it and now I want to switch for a Linux system.

My question is: will I be able to play my archive logs and point-in-time recover on the Linux machine?

That would spare some time rebuilding a Windows machine, recovering my db, and dumping for a Linux box.

Thanks for your advice.

Guillaume

On 4/13/15 6:37 PM, Guillaume Drolet wrote:
> Dear list,
>
> I have a base backup and archive logs from a Windows 7 PGSQL 9.3
> install. The machine OS disk started to show signs of failure so I
> replaced it and now I want to switch for a Linux system.
>
> My question is: will I be able to play my archive logs and point-in-time
> recover on the Linux machine?
>
> That would spare some time rebuilding a Windows machine, recovering my
> db, and dumping for a Linux box.

No. You can only use a PITR backup on an install that's completely
binary compatible with the installation the backup was taken from. Not
only does the OS have to match, you could actually run into problems
switching to a different CPU architecture (among other things, whether
the architecture is big- or small-endian matters).
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

On 04/13/2015 04:37 PM, Guillaume Drolet wrote:
> Dear list,
>
> I have a base backup and archive logs from a Windows 7 PGSQL 9.3
> install. The machine OS disk started to show signs of failure so I
> replaced it and now I want to switch for a Linux system.
>
> My question is: will I be able to play my archive logs and point-in-time
> recover on the Linux machine?

No. The machines have to be the same OS/architecture.

>
> That would spare some time rebuilding a Windows machine, recovering my
> db, and dumping for a Linux box.
>
> Thanks for your advice.
>
> Guillaume
>


--
Adrian Klaver
adrian.klaver@aklaver.com