On Wed, Jul 5, 2017 at 9:03 PM, Om Prakash Jaiswal <op12om@xxxxxxxxxxx> wrote: > Replication is possible between two OS. > You can use BUCARDO Asynchronous replication system. Which follow TCP/IP > standard protocol, > It does not matter which OS you are using. Only nature and signature(Table > name and data type) should match. > > It may be some other tools like slony, rubyrep also work. Because they also > use TCP/IP protocol. > Although Bucardo I have used across two operating system RHEL 6(32bit) and > RHEL7(64bit). It is working. > > Regards > Om Prakash > DBA, Bangalore > Mob: 9035635787 > > > On Thursday, 6 July 2017 5:01 AM, Wei Shan <weishan.ang@xxxxxxxxx> wrote: > > > Hi all! > > Is it possible setup streaming replication between different OS? > > For example, between RHEL6 and RHEL7. I understand that it is not possible > between Windows and Linux.I need to migrate a PostgreSQL instance to a new > host, while upgrading the OS if possible. > > Has anyone done this before? They key here is that your postgresql's need to agree on things like date format etc and be in teh same binary format. I do know that with linux they don't have to have the same OS underneath them. Just the same basic postgresql version. Not sure on windows to linux though. Never done that. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
