Re: Cluster on NAS and data center. - Mailing list pgsql-hackers

From Matt Kelly
Subject Re: Cluster on NAS and data center.
Date
Msg-id CA+KcUkixyFmWeffsPq=XqcGbKYj4kkkhCeMW=A-M3HB6z80yrA@mail.gmail.com
Whole thread Raw
In response to Re: Cluster on NAS and data center.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Cluster on NAS and data center.  (Krzysztof Kaczkowski <grafvader@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cluster on NAS and data center.
Next
From: Tom Lane
Date:
Subject: Re: oddity in initdb probing of max_connections/shared_buffers