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 (we

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 u

Re: [Pacemaker] Properly fencing Postgres

2010-03-05 Thread Serge Dubrouski
On Fri, Mar 5, 2010 at 7:56 AM, Martin Aspeli 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. pgs

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.

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 thi

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

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 f

[Pacemaker] Properly fencing Postgres

2010-03-04 Thread Martin Aspeli
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 fencing/STONITH, before we dive into trying to set this up. We're using Su