Postgres Pro
Downloads
Home   >   mailing lists

How to compile a 32 bit version of postgres on a x64 machine. - Mailing list pgsql-general

From Tim Uckun
Subject How to compile a 32 bit version of postgres on a x64 machine.
Date
Msg-id 855e4dcf0903260343x656ce8cdgeefa9324d5c3e811@mail.gmail.com
Whole thread Raw
Responses Re: How to compile a 32 bit version of postgres on a x64 machine.  (Douglas McNaught <doug@mcnaught.org>)
List pgsql-general
Tree view
It looks like most avenues for high availability with postgres are not available if one of the machines is a 64 bit machine and the other a 32.

Somebody on this list suggested I install a 32 bit version of postgres on my x64 machine.  What's the best way to handle this? Should I compile it fresh? Install the 32 bit binaries? Can I just copy the binaries from the secondary?

I presume I am going to have to drop all the databases and reload them of course.

Here are the uname -a of both machines.

The primary  2.6.27-11-server #1 SMP Thu Jan 29 20:13:12 UTC 2009 x86_64 GNU/Linux

The secondary  2.6.27-11-server #1 SMP Thu Jan 29 20:19:41 UTC 2009 i686 GNU/Linux

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: intermittant performance problem
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: idle connection timeout