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

[Joar Jegleim]

looking at http://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=9cf159246892e3388b36f4b43cccc0c62e54a29f
, I'm not sure if that check work .
The buttons are greyed out for me ( see previous attached screendump)
, but as far as I understand I am superuser.
I'm logged in as postgres, and as far as I know pgpooladmin connects
to the postgres servers as postgres user, which is superuser .

I removed the || $is_superuser !== 'yes' from
templates/elements/status_pgsql_buttons.tpl , then I can use the
buttons .

Now when I press f.example 'stop' button in pgpooladmin status screen,
she postgres server logs:

ERROR:  unrecognized configuration parameter "pgpool.pg_ctl"
16716 2014-04-09 14:48:16 CEST STATEMENT:  SELECT pgpool_pgctl('stop', 'f')

What am I missing here (?)
I've installed the stuff from sql/pgpool-recovery and sql/pgpool-regclass :
cd sql/pgpool-recovery
make
make install
psql -f pgpool-recovery.sql template1
psql -f pgpool-recovery.sql postgres
cd ../pgpool-regclass
make
make install
psql -f pgpool-regclass.sql template1
psql -f pgpool-regclass.sql postgres

is there some other sql files, or code / extensions I've missed that
implement the pgpool.pg_ctl configuration parameter (?)

regards
Joar




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


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

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


-- 
----------------------
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/6442f041/attachment-0001.png>