Обсуждение: Cluster on NAS and data center.

Поиск
Список
Период
Сортировка

Cluster on NAS and data center.

От
Krzysztof Kaczkowski
Дата:

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?

Re: Cluster on NAS and data center.

От
Adrian Klaver
Дата:
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@aklaver.com

Re: Cluster on NAS and data center.

От
Melvin Davidson
Дата:


On Mon, Jul 4, 2016 at 10:01 AM, Adrian Klaver <adrian.klaver@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.klaver@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.

Re: Cluster on NAS and data center.

От
Krzysztof Kaczkowski
Дата:

Hello,

Thanks to emails, we have achieved what we wanted. This is what we’ve done:

Compilation:

CFLAGS="-mx32 -fexcess-precision=standard -O2"

CXXFLAGS="-mx32"

./configure --without-zlib --disable-float8-byval --without-readline --host=x86_64-linux-gnux32

We also have installed libx32.

Right now we received cluster that is fully manageable from both systems. Anyone see something dangerous with this compilation?