From: | Wei Shan <weishan(dot)ang(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "Mark Kirkwood *EXTERN*" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Questions on Streaming Replication |
Date: | 2017-07-07 14:32:07 |
Message-ID: | CAFe9ZTp2aW3E3EPMC59fP4pG7Y2+cogS4LvduBSPUdqaJhaujQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Laurenz,
But the same version of glibc will be different on RHEL6/RHEL7 isn't it?
Look here: http://distrowatch.com/table.php?distribution=redhat
On 7 July 2017 at 12:11, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> > 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
>
--
Regards,
Ang Wei Shan
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2017-07-07 14:49:17 | Re: Questions on Streaming Replication |
Previous Message | Albe Laurenz | 2017-07-07 11:11:48 | Re: Questions on Streaming Replication |