Re: Cluster on NAS and data center.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Krzysztof Kaczkowski <grafvader(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Cluster on NAS and data center.
Date: 2016-07-04 14:34:27
Message-ID: 18240.1467642867@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Craig Ringer <craig(at)2ndquadrant(dot)com> writes:
> On 4 July 2016 at 17:33, Krzysztof Kaczkowski <grafvader(at)gmail(dot)com> wrote:
>> We know that standard PostgreSQL is not able to use cluster created on
>> different OS. We think that recompilation PostgreSQL with some specific
>> flags. This should give us compatibility of cluster on different Systems.
>> We see a small differences in cluster files on binary level. Can You help
>> us pick proper compilation flags?

> I wouldn't recommend that, and it might be pretty tricky.

Indeed. Aside from architectural differences, I'd be very afraid of
differences in collation order (resulting in incompatible indexes on
textual columns). You might be able to make it work if you only ever
use "C" locale. But really, this is not and will never be considered
supported usage, and if it fails, no one is going to say anything
except "we warned you not to do that".

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matt Kelly 2016-07-04 15:04:28 Re: Cluster on NAS and data center.
Previous Message Amit Kapila 2016-07-04 14:33:38 Re: to_date_valid()