[pgpool-general: 2736] Fwd: pgpooladmin start / stop / restart buttons greyed out

Joar Jegleim joar.jegleim at gmail.com
Wed Apr 9 18:18:44 JST 2014


I got the promote button to work after looking at the pcp_promoet_node
command + http://lists.pgfoundry.org/pipermail/pgpool-hackers/2011-January/000544.html
So I setup :
follow_master_command = '/usr/local/sbin/failover.sh %d "%h" %p %D %m
%M "%H" %P'

and now, when I push 'promote' the current primary is disconnected,
and the standby is promoted to master .
For manual promotoion I'd also like the old master to simply be
remoted to standby and deliver read requests, I'll look into that .

But I'd still like to figure out how to enable those start / stop etc.
buttons from pgpool admin interface

regards
jj



---------- Forwarded message ----------
From: Joar Jegleim <joar.jegleim at gmail.com>
Date: 9 April 2014 10:47
Subject: pgpooladmin start / stop / restart buttons greyed out
To: pgpool-general at pgpool.net


Hi list,

I'm building a 2 node postgres streamin replication cluster with
pgpool in front .
I've followed the howto at
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index.html

I'm using postgres 9.3 and got pgpool 3.3.2 and pgpoolAdmin 3.3.1

the stop/start/reload/remove buttons in the status page are grey'ed
out and can't be used.
How do I enable those ?

And I can't seem to figure out how the 'promote' button is supposed to work ...
At first I reckoned that pressing the promote button would promote
standby -> master, and demote master to standby.

When I press the 'promote' button, the master node disconnects, but
the standby is not promoted to master .
I struggle to figure out where to debug this 'cause I don't see
anything happening in any logs either.

Does anybody have the same problem ? or could somebody walk me through
the process of what's happening when I push the 'promote' button, e.g.
is it the 'failover.sh' script that is called first ?




--
----------------------
Joar Jegleim
Homepage: http://cosmicb.no
Linkedin: http://no.linkedin.com/in/joarjegleim
fb: http://www.facebook.com/joar.jegleim
AKA: CosmicB @Freenode

----------------------


-- 
----------------------
Joar Jegleim
Homepage: http://cosmicb.no
Linkedin: http://no.linkedin.com/in/joarjegleim
fb: http://www.facebook.com/joar.jegleim
AKA: CosmicB @Freenode

----------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_admin.png
Type: image/png
Size: 135322 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140409/b7330209/attachment-0001.png>


More information about the pgpool-general mailing list