On Mon, Jul 4, 2016 at 10:01 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
