Re: [Pacemaker] configuring postgresql streaming replication cluster

2013-06-13 Thread Takatoshi MATSUO
2013/6/13 Gregg Jaskiewicz : > > On 13 June 2013 10:51, Takatoshi MATSUO wrote: >> >> Hi >> >> > As far the logs go, anything specific I should be grepping for ? >> >> Please grep pgsql >> >> > node_list="hanode01 hanode02" \ >> >> You need to add all node names whose replication is controlled by

Re: [Pacemaker] configuring postgresql streaming replication cluster

2013-06-13 Thread Gregg Jaskiewicz
On 13 June 2013 10:51, Takatoshi MATSUO wrote: > Hi > > > As far the logs go, anything specific I should be grepping for ? > > Please grep pgsql > > > node_list="hanode01 hanode02" \ > > You need to add all node names whose replication is controlled by > Pacemaker. > > > pcs resource master msPos

Re: [Pacemaker] configuring postgresql streaming replication cluster

2013-06-13 Thread Takatoshi MATSUO
Hi > As far the logs go, anything specific I should be grepping for ? Please grep pgsql > node_list="hanode01 hanode02" \ You need to add all node names whose replication is controlled by Pacemaker. > pcs resource master msPostgresql pgsql master-max=1 master-node-max=1 > clone-max=10 clone-n

Re: [Pacemaker] configuring postgresql streaming replication cluster

2013-06-13 Thread Gregg Jaskiewicz
On 12 June 2013 06:59, Takatoshi MATSUO wrote: > Hi Gregg > > Can you show me the output of "crm_mon -Afr" ? > And please see pacemaker log. > Pgsql RA may output some reasons why slave cann't be promoted. > > Last updated: Thu Jun 13 08:06:26 2013 Last change: Tue Jun 11 12:46:54 2013 via cibad

Re: [Pacemaker] configuring postgresql streaming replication cluster

2013-06-11 Thread Takatoshi MATSUO
Hi Gregg Can you show me the output of "crm_mon -Afr" ? And please see pacemaker log. Pgsql RA may output some reasons why slave cann't be promoted. Thanks, Takatoshi MATSUO 2013/6/12 Andrew Beekhof : > > On 11/06/2013, at 10:05 PM, Gregg Jaskiewicz wrote: > >> Hi guys, >> >> I'm trying to wra

Re: [Pacemaker] configuring postgresql streaming replication cluster

2013-06-11 Thread Andrew Beekhof
On 11/06/2013, at 10:05 PM, Gregg Jaskiewicz wrote: > Hi guys, > > I'm trying to wrap my head around the pacemaker, and setting up postgresql > cluster using pcs on centos 6.4. > > I used so far following commands to set it up. And this seems to work, but > all nodes are running as slaves