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 (postgresql wise).
The 'master' node (IP address wise) even connects
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
How does one convert a rule in CRM to PCS, that is bit more complicated.
Like so:
location rsc_location-2 msPostgreSQL \
rule $id="rsc_location-2-rule" $role="master" 200: #uname eq dev02 \
rule $id="rsc_location-2-rule-0" $role="master" 100: #uname eq
dev01 \
rule $id="rsc
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
Hey folks,
Following few battles with the thing - I managed to get pgsql RA to run on
4 nodes, it's all great, however...
When testing the failover, I unplugged the 'master' machine, the slaves are
getting sorted out, new master is elected, however the slaves now don't
reconnect to the new master.
Running rsync -avzPc -e 'ssh -o UserKnownHostsFile=/dev/null'
--delete-during 10.0.1.100:/var/lib/pgsql/9.2/data/pg_archive
/var/lib/pgsql/9.2/data/
on each slave fixes it - but question then is - why cannot this be
done automatically by RA ?
Andrew on irc suggested I use restart_on_promote, but
Hi Guys,
I need to write an resource agent for our little service here.
The service will only run on the same node as PostgreSQL master.
However, the service needs to know eth0 IPs of every 'slave' postgresql
node.
Each node's host name represents its eth1 IP.
What's the best way to accomplish t
rm_resource --get-parameter --resource $ANOTHER_RESOURCE
> and cycle through the list of Postgres children (filtering out those
> running as Master or Stopped)
>
> On 26/08/2013, at 6:00 PM, Gregg Jaskiewicz wrote:
>
> > Hi Guys,
> >
> > I need to write an resourc
Hi guys,
So I have to change one of the 'primitives' configuration, in this case
pgsql - to add a new node or remove it.
I'd like to script it.
Atm someone has to go in and manually run:
crm configuration edit pgsql
change the setting, and save it.
How could one do this automatically in a script
