Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-27 Thread Sam Mason
On Fri, Mar 27, 2009 at 10:32:33AM +1300, Tim Uckun wrote: What about running a 32bit build of PG on the 64bit machine? How would one go about doing something like this? Depending on your distribution you should be able to install 32bit binaries alongside 64bit binaries; for example in

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-26 Thread Chander Ganesan
Tatsuo Ishii wrote: I know what you think:-) Problem is, he asks high availabilty, that means, no SPOF, minimum down time. For the purpose, I suppose pgpool-HA(actually heartbeat)+pgpool-II+Slony-I might work, but I'm not sure heartbeat does work with 32/64bit combo. Heartbeat does work

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-26 Thread Sam Mason
On Thu, Mar 26, 2009 at 02:08:33PM +1300, Tim Uckun wrote: On Thu, Mar 26, 2009 at 2:05 PM, Tatsuo Ishii is...@postgresql.org wrote: According to the documentation it's not possible to log ship from a 64 bit server to a 32 bit server. I think the doc is quite correct. So what is

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-26 Thread Tim Uckun
What about running a 32bit build of PG on the 64bit machine? How would one go about doing something like this?

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-26 Thread Scott Marlowe
On Thu, Mar 26, 2009 at 3:32 PM, Tim Uckun timuc...@gmail.com wrote: What about running a 32bit build of PG on the 64bit machine? How would one go about doing something like this? Compiling with the proper -march flags I believe. It's been like 5 years since I had to mess with such

[GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Tim Uckun
According to the documentation it's not possible to log ship from a 64 bit server to a 32 bit server. I just want to confirm that this is the case before I waste a whole lot of time trying to set it up.

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Tatsuo Ishii
According to the documentation it's not possible to log ship from a 64 bit server to a 32 bit server. I think the doc is quite correct. -- Tatsuo Ishii SRA OSS, Inc. Japan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Tim Uckun
On Thu, Mar 26, 2009 at 2:05 PM, Tatsuo Ishii is...@postgresql.org wrote: According to the documentation it's not possible to log ship from a 64 bit server to a 32 bit server. I think the doc is quite correct. So what is the best way to accomplish a failover from a 64 bit machine to a

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Scott Marlowe
On Wed, Mar 25, 2009 at 7:08 PM, Tim Uckun timuc...@gmail.com wrote: On Thu, Mar 26, 2009 at 2:05 PM, Tatsuo Ishii is...@postgresql.org wrote: According to the documentation it's not possible to log ship from a 64 bit server  to a 32 bit server. I think the doc is quite correct. So

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Tim Uckun
slony? That sound more like a question than an answer :) Can I presume it doesn't care about the architecture of the OS?

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Tatsuo Ishii
According to the documentation it's not possible to log ship from a 64 bit server  to a 32 bit server. I think the doc is quite correct. So what is the best way to accomplish a failover from a 64 bit machine to a 32 bit machine? slony? IMO Slony doesn't do failover. --

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Scott Marlowe
On Wed, Mar 25, 2009 at 8:23 PM, Tatsuo Ishii is...@postgresql.org wrote: According to the documentation it's not possible to log ship from a 64 bit server  to a 32 bit server. I think the doc is quite correct. So what is the best way to accomplish a failover from a 64 bit

Re: [GENERAL] log shipping from 64 bit linux server to a 32 bit linux server

2009-03-25 Thread Tatsuo Ishii
According to the documentation it's not possible to log ship from a 64 bit server  to a 32 bit server. I think the doc is quite correct. So what is the best way to accomplish a failover from a 64 bit machine to a 32 bit machine? slony? IMO Slony doesn't do