From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'Mark Kirkwood *EXTERN*'" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Wei Shan <weishan(dot)ang(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Questions on Streaming Replication |
Date: | 2017-07-07 11:11:48 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B53A80097@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> On 06/07/17 11:29, Wei Shan wrote:
>> 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?
Mark Kirkwood wrote:
> I think you should be ok between different versions of Linux, provided:
>
> - both systems use hardware with same endianness and bitness (e.g both
> 64 bit Intel say)
>
> - both OS are the same bitness (e.g both 64 bit)
And, very importeant, if they don't have different versions of libc
that have different ideas about character collation.
See also https://www.postgresql.org/message-id/CB4D1C6BAA80CF146CB0D4F2%40eje.credativ.lan
RHEL6:
$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.9 (Santiago)
$ echo -e '156\n1-5-6\n110\n1-1-0' | LANG=de_DE.UTF-8 sort
1-1-0
110
1-5-6
156
RHEL7:
$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.3 (Maipo)
$ echo -e '156\n1-5-6\n110\n1-1-0' | LANG=de_DE.UTF-8 sort
110
1-1-0
156
1-5-6
So you are probably OK as long as you are only using the C collation, but
if you have any indexes that use a collation that is different on both systems,
The index on the standby will be corrupted.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Wei Shan | 2017-07-07 14:32:07 | Re: Questions on Streaming Replication |
Previous Message | Wei Shan | 2017-07-06 08:28:09 | Re: Questions on Streaming Replication |