Re: Cluster on NAS and data center.
От | Matt Kelly |
---|---|
Тема | Re: Cluster on NAS and data center. |
Дата | |
Msg-id | CA+KcUkixyFmWeffsPq=XqcGbKYj4kkkhCeMW=A-M3HB6z80yrA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Cluster on NAS and data center. (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Cluster on NAS and data center.
|
Список | pgsql-hackers |
<div dir="ltr"><div style="white-space:pre-wrap">As someone who has bitten by index corruption due to collation changes betweenglibc versions that shipped CentOS 6 and CentOS 7, don't even try to do this with anything other than C collation.The default collation _will_ deterministically leave you with a silently corrupt database if you store anythingother than ASCII text. Windows and Linux are going to implement en_US.utf-8 slightly differently and Postgres iscurrently relying on the OS to provide collation implementations. Go search for my mailing list post about the dangersof running across versions of glibc for more info.<br /><br />I'm going to echo everyone else's sentiment though,and assert that what you are trying to do is really an insane idea. You might be able to make it appear like its workingbut as a DBA, I would have absolutely no confidence in using that server for disaster recovery.<br /><br />If yourcompany is saving money by not getting Windows licenses for your DR environment, you are far better off just saving onemore license and making both your production and DR server be Linux builds.<br /><br />- Matt K.</div></div>
В списке pgsql-hackers по дате отправления: