Re: [Pacemaker] Properly fencing Postgres

2010-03-09 Thread Martin Aspeli
Hi Dejan, Thanks for all the help! - The postgres data would need fencing when failing over, from what I understand. I read the notes that using an on-board device like Dell's DRAC to implemenet STONITH is not a good idea. We don't have the option at this stage to buy a UPS-based solution

Re: [Pacemaker] Properly fencing Postgres

2010-03-08 Thread Dejan Muhamedagic
Hi, On Fri, Mar 05, 2010 at 10:50:30PM +0800, Martin Aspeli wrote: Hi Dejan, Dejan Muhamedagic wrote: Hi, On Fri, Mar 05, 2010 at 10:00:06AM +0800, Martin Aspeli wrote: [...] - I'm not sure we need to use Pacemaker to manage HAProxy on slave; it will simply not be used until the IP

Re: [Pacemaker] Properly fencing Postgres

2010-03-05 Thread Dejan Muhamedagic
Hi, On Fri, Mar 05, 2010 at 10:00:06AM +0800, Martin Aspeli wrote: Hi, I'm pretty new to all this stuff, but I've read pretty much all the documentation on the clusterlabs website. I'm seeking a bit of clarification/confirmation on how to achieve certain things, in particular around

Re: [Pacemaker] Properly fencing Postgres

2010-03-05 Thread Serge Dubrouski
I don't know if the pgsql RA can support cold standby instances. In my opinion cold standby is a server has has access to the data files where PostreSQL is down but can be brought up any time. pgsql RA does exactly that if other resources proved access to the data. What pgsql RA doesn't do is

Re: [Pacemaker] Properly fencing Postgres

2010-03-05 Thread Martin Aspeli
Hi Dejan, Dejan Muhamedagic wrote: Hi, On Fri, Mar 05, 2010 at 10:00:06AM +0800, Martin Aspeli wrote: Hi, I'm pretty new to all this stuff, but I've read pretty much all the documentation on the clusterlabs website. I'm seeking a bit of clarification/confirmation on how to achieve certain

Re: [Pacemaker] Properly fencing Postgres

2010-03-05 Thread Martin Aspeli
Hi Serge, I don't know if the pgsql RA can support cold standby instances. In my opinion cold standby is a server has has access to the data files where PostreSQL is down but can be brought up any time. pgsql RA does exactly that if other resources proved access to the data. What pgsql

Re: [Pacemaker] Properly fencing Postgres

2010-03-05 Thread Serge Dubrouski
On Fri, Mar 5, 2010 at 7:56 AM, Martin Aspeli optilude+li...@gmail.com wrote: Hi Serge, Hello - I don't know if the pgsql RA can support cold standby instances. In my opinion cold standby is a server has has access to the data files where PostreSQL is down but can be brought up any time.