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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Adrian, Jim: thanks a lot for your help. I'll replay my logs on a Windows
machine very similar to the one that was hosting my db and see how it goes
before I make a pg_dump for Linux.
2015-04-13 21:49 GMT-04:00 Adrian Klaver <adrian.klaver@aklaver.com>:
Show quoted text
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