Re: [HACKERS] Cluster on NAS and data center.

2016-07-05 Thread Krzysztof Kaczkowski
Hello,

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

Compilation (for 32 bit version, initdb with locale=C):

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?


Re: [HACKERS] Cluster on NAS and data center.

2016-07-04 Thread Krzysztof Kaczkowski
Hello,

About Your question, please do not ask. This infrastructure is an outcome
of a very long talk with supervisors.

Back to the topic. I like the tricky part. Do You think there is some way
to achieve this on compilation level or shall we search somewhere else? For
example UNIX libraries or even change and recompile kernel?


[HACKERS] Cluster on NAS and data center.

2016-07-04 Thread 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?