<p dir="ltr">Thank you for replying me, and you're right, I haven't added the pgpool.pg_ctl configuration directive. <br>
I hate that I missed that part from the docs.</p>
<p dir="ltr">I'm going to look at this when I'm back from vacation next week.</p>
<p dir="ltr">Thanks !</p>
<div class="gmail_quote">On 17 Apr 2014 03:50, "Nozomi Anzai" <<a href="mailto:anzai@sraoss.co.jp">anzai@sraoss.co.jp</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
Sorry for the late reply.<br>
<br>
> What am I missing here (?)<br>
> I've installed the stuff from sql/pgpool-recovery and sql/pgpool-regclass :<br>
> cd sql/pgpool-recovery<br>
> make<br>
> make install<br>
> psql -f pgpool-recovery.sql template1<br>
> psql -f pgpool-recovery.sql postgres<br>
> cd ../pgpool-regclass<br>
> make<br>
> make install<br>
> psql -f pgpool-regclass.sql template1<br>
> psql -f pgpool-regclass.sql postgres<br>
<br>
These steps seem OK.<br>
<br>
> is there some other sql files, or code / extensions I've missed that<br>
> implement the pgpool.pg_ctl configuration parameter (?)<br>
<br>
No, there aren't more sql files.<br>
But I wonder if you mean "pgpool.pg_ctl" parameter might be added<br>
automatically (by sql file, etc.)? This parameter is the one the user<br>
has to add by himself.<br>
<br>
"Configuring pgpool.pg_ct":<br>
<a href="http://www.pgpool.net/docs/latest/pgpool-en.html#install_functions" target="_blank">http://www.pgpool.net/docs/latest/pgpool-en.html#install_functions</a><br>
<br>
| The function pgpool_pgctl executes the command whose path is specified<br>
| by "pgpool.pg_ctl" in postgresql.conf. To use this function, you have<br>
| to specify this parameter.<br>
| ----<br>
| ex)<br>
| $ cat >> /usr/local/pgsql/postgresql.conf<br>
| pgpool.pg_ctl = '/usr/local/pgsql/bin/pg_ctl'<br>
|<br>
| $ pg_ctl reload -D /usr/local/pgsql/data<br>
| ----<br>
<br>
<br>
> looking at <a href="http://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=9cf159246892e3388b36f4b43cccc0c62e54a29f" target="_blank">http://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=9cf159246892e3388b36f4b43cccc0c62e54a29f</a><br>
> , I'm not sure if that check work .<br>
> The buttons are greyed out for me ( see previous attached screendump)<br>
> , but as far as I understand I am superuser.<br>
> I'm logged in as postgres, and as far as I know pgpooladmin connects<br>
> to the postgres servers as postgres user, which is superuser .<br>
><br>
> I removed the || $is_superuser !== 'yes' from<br>
> templates/elements/status_pgsql_buttons.tpl , then I can use the<br>
> buttons .<br>
><br>
> Now when I press f.example 'stop' button in pgpooladmin status screen,<br>
> she postgres server logs:<br>
><br>
> ERROR: unrecognized configuration parameter "pgpool.pg_ctl"<br>
> 16716 2014-04-09 14:48:16 CEST STATEMENT: SELECT pgpool_pgctl('stop', 'f')<br>
><br>
> What am I missing here (?)<br>
> I've installed the stuff from sql/pgpool-recovery and sql/pgpool-regclass :<br>
> cd sql/pgpool-recovery<br>
> make<br>
> make install<br>
> psql -f pgpool-recovery.sql template1<br>
> psql -f pgpool-recovery.sql postgres<br>
> cd ../pgpool-regclass<br>
> make<br>
> make install<br>
> psql -f pgpool-regclass.sql template1<br>
> psql -f pgpool-regclass.sql postgres<br>
><br>
> is there some other sql files, or code / extensions I've missed that<br>
> implement the pgpool.pg_ctl configuration parameter (?)<br>
><br>
> regards<br>
> Joar<br>
><br>
><br>
><br>
><br>
> ---------- Forwarded message ----------<br>
> From: Joar Jegleim <<a href="mailto:joar.jegleim@gmail.com">joar.jegleim@gmail.com</a>><br>
> Date: 9 April 2014 11:18<br>
> Subject: Fwd: pgpooladmin start / stop / restart buttons greyed out<br>
> To: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
><br>
><br>
> I got the promote button to work after looking at the pcp_promoet_node<br>
> command + <a href="http://lists.pgfoundry.org/pipermail/pgpool-hackers/2011-January/000544.html" target="_blank">http://lists.pgfoundry.org/pipermail/pgpool-hackers/2011-January/000544.html</a><br>
> So I setup :<br>
> follow_master_command = '/usr/local/sbin/failover.sh %d "%h" %p %D %m<br>
> %M "%H" %P'<br>
><br>
> and now, when I push 'promote' the current primary is disconnected,<br>
> and the standby is promoted to master .<br>
> For manual promotoion I'd also like the old master to simply be<br>
> remoted to standby and deliver read requests, I'll look into that .<br>
><br>
> But I'd still like to figure out how to enable those start / stop etc.<br>
> buttons from pgpool admin interface<br>
><br>
> regards<br>
> jj<br>
><br>
><br>
><br>
> ---------- Forwarded message ----------<br>
> From: Joar Jegleim <<a href="mailto:joar.jegleim@gmail.com">joar.jegleim@gmail.com</a>><br>
> Date: 9 April 2014 10:47<br>
> Subject: pgpooladmin start / stop / restart buttons greyed out<br>
> To: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
><br>
><br>
> Hi list,<br>
><br>
> I'm building a 2 node postgres streamin replication cluster with<br>
> pgpool in front .<br>
> I've followed the howto at<br>
> <a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index.html" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index.html</a><br>
><br>
> I'm using postgres 9.3 and got pgpool 3.3.2 and pgpoolAdmin 3.3.1<br>
><br>
> the stop/start/reload/remove buttons in the status page are grey'ed<br>
> out and can't be used.<br>
> How do I enable those ?<br>
><br>
> And I can't seem to figure out how the 'promote' button is supposed to work ...<br>
> At first I reckoned that pressing the promote button would promote<br>
> standby -> master, and demote master to standby.<br>
><br>
> When I press the 'promote' button, the master node disconnects, but<br>
> the standby is not promoted to master .<br>
> I struggle to figure out where to debug this 'cause I don't see<br>
> anything happening in any logs either.<br>
><br>
> Does anybody have the same problem ? or could somebody walk me through<br>
> the process of what's happening when I push the 'promote' button, e.g.<br>
> is it the 'failover.sh' script that is called first ?<br>
><br>
><br>
><br>
><br>
> --<br>
> ----------------------<br>
> Joar Jegleim<br>
> Homepage: <a href="http://cosmicb.no" target="_blank">http://cosmicb.no</a><br>
> Linkedin: <a href="http://no.linkedin.com/in/joarjegleim" target="_blank">http://no.linkedin.com/in/joarjegleim</a><br>
> fb: <a href="http://www.facebook.com/joar.jegleim" target="_blank">http://www.facebook.com/joar.jegleim</a><br>
> AKA: CosmicB @Freenode<br>
><br>
> ----------------------<br>
><br>
><br>
> --<br>
> ----------------------<br>
> Joar Jegleim<br>
> Homepage: <a href="http://cosmicb.no" target="_blank">http://cosmicb.no</a><br>
> Linkedin: <a href="http://no.linkedin.com/in/joarjegleim" target="_blank">http://no.linkedin.com/in/joarjegleim</a><br>
> fb: <a href="http://www.facebook.com/joar.jegleim" target="_blank">http://www.facebook.com/joar.jegleim</a><br>
> AKA: CosmicB @Freenode<br>
><br>
> ----------------------<br>
><br>
><br>
> --<br>
> ----------------------<br>
> Joar Jegleim<br>
> Homepage: <a href="http://cosmicb.no" target="_blank">http://cosmicb.no</a><br>
> Linkedin: <a href="http://no.linkedin.com/in/joarjegleim" target="_blank">http://no.linkedin.com/in/joarjegleim</a><br>
> fb: <a href="http://www.facebook.com/joar.jegleim" target="_blank">http://www.facebook.com/joar.jegleim</a><br>
> AKA: CosmicB @Freenode<br>
><br>
> ----------------------<br>
<br>
<br>
--<br>
Nozomi Anzai<br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div>