Re: Cluster on NAS and data center.

On Mon, Jul 4, 2016 at 10:01 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 07/04/2016 02:35 AM, Krzysztof Kaczkowski wrote:
>
>> Hello everyone,
>>
>> Right now we have PostgreSQL on Windows Server (main data center) and
>> cluster is placed on NAS. We have emergency data center on UNIX
>> architecture. We want that emergency data center could continue work on
>> PostgreSQL cluster that has been used by Windows PostgreSQL.
>>
>> 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?
>>
>>
> If that where possible tools like pg_upgrade would be able to upgrade
> between OSes.
>
> What do you want the role of the UNIX data center to be, a continuous
> standby, a place where you store backups, something else?
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Even if this were possible, it happens to be a very bad idea. The whole
concept of a backup/failover system is that it is a duplicate of the
production. So even if
you think you have it working, you are just asking for trouble when the
time comes to do a failover. Seriously, decide on one O/S and use it.

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.