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

2016-07-07 Thread Robert Haas
On Tue, Jul 5, 2016 at 7:46 AM, Krzysztof Kaczkowski wrote: > 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" > >

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

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

2016-07-04 Thread Matt Kelly
As someone who has bitten by index corruption due to collation changes between glibc versions that shipped CentOS 6 and CentOS 7, don't even try to do this with anything other than C collation. The default collation _will_ deterministically leave you with a silently corrupt database if you store

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

2016-07-04 Thread Tom Lane
Craig Ringer writes: > On 4 July 2016 at 17:33, Krzysztof Kaczkowski wrote: >> 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

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

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

2016-07-04 Thread Craig Ringer
On 4 July 2016 at 17:33, 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

[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