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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
