On Mon, Jul 4, 2016 at 10:01 AM, Adrian Klaver <adrian.kla...@aklaver.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.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.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.