Re: [Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster

2014-01-14 Thread Andrew Beekhof
On 14 Jan 2014, at 10:32 pm, Andrey Rogovsky wrote: > I understand it. So, no way change master better without cluster software > update? crm_resource is just creating (and removing) normal location constraints. no reason you couldn't write a script to create them instead. > > > > 2014/1/1

Re: [Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster

2014-01-14 Thread Andrey Rogovsky
Thanks a lot. 2014/1/14 Andrey Groshev > > > 14.01.2014, 15:37, "Andrey Rogovsky" : > > I understand it. So, no way change master better without cluster software > update? > > > > You can send a node in standby (crm_stanbdy). > All resources will move to another node (if available). > Pgsql re

Re: [Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster

2014-01-14 Thread Andrey Groshev
  14.01.2014, 15:37, "Andrey Rogovsky" :I understand it. So, no way change master better without cluster software update?  You can send a node in standby (crm_stanbdy).All resources will move to another node (if available).Pgsql resource agent will promote postgresql on another node.Anyway ex Maste

Re: [Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster

2014-01-14 Thread Andrey Rogovsky
I understand it. So, no way change master better without cluster software update? 2014/1/14 Andrey Groshev > > > 14.01.2014, 12:39, "Andrey Rogovsky" : > > I use Debian 7 and got: > Reconnecting...root@a:~# crm_resource --resource msPostgresql --ban > --master --host a.geocluster.e-autopay.com

Re: [Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster

2014-01-14 Thread Andrey Groshev
  14.01.2014, 12:39, "Andrey Rogovsky" :I use Debian 7 and got:Reconnecting...root@a:~# crm_resource --resource msPostgresql --ban --master --host a.geocluster.e-autopay.comcrm_resource: unrecognized option '--ban'  No other way to move master? 2014/1/13 Andrew Beekhof On 13 Ja

Re: [Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster

2014-01-14 Thread Andrey Rogovsky
I use Debian 7 and got: Reconnecting...root@a:~# crm_resource --resource msPostgresql --ban --master --host a.geocluster.e-autopay.com crm_resource: unrecognized option '--ban' No other way to move master? 2014/1/13 Andrew Beekhof > > On 13 Jan 2014, at 8:32 pm, Andrey Rogovsky wrote: > > >

Re: [Pacemaker] [Linux-HA] Better way to change master in 3 node pgsql cluster

2014-01-13 Thread Andrew Beekhof
On 13 Jan 2014, at 8:32 pm, Andrey Rogovsky wrote: > Hi > > I have 3 node postgresql cluster. > It work well. But I have some trobule with change master. > > For now, if I need change master, I must: > 1) Stop PGSQL on each node and cluster service > 2) Start Setup new manual PGSQL replication