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

[Nozomi Anzai]

Hi,

Sorry for the late reply.

> 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

These steps seem OK.

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

No, there aren't more sql files.
But I wonder if you mean "pgpool.pg_ctl" parameter might be added
automatically (by sql file, etc.)?  This parameter is the one the user
has to add by himself.

"Configuring pgpool.pg_ct":
http://www.pgpool.net/docs/latest/pgpool-en.html#install_functions

| The function pgpool_pgctl executes the command whose path is specified
| by "pgpool.pg_ctl" in postgresql.conf. To use this function, you have
| to specify this parameter.
| ----
| ex)
| $ cat >> /usr/local/pgsql/postgresql.conf
| pgpool.pg_ctl = '/usr/local/pgsql/bin/pg_ctl'
| 
| $ pg_ctl reload -D /usr/local/pgsql/data
| ----


> 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 ¡÷ gmail.com>
> Date: 9 April 2014 11:18
> Subject: Fwd: pgpooladmin start / stop / restart buttons greyed out
> To: pgpool-general ¡÷ 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 ¡÷ gmail.com>
> Date: 9 April 2014 10:47
> Subject: pgpooladmin start / stop / restart buttons greyed out
> To: pgpool-general ¡÷ 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
> 
> ----------------------


-- 
Nozomi Anzai
SRA OSS, Inc. Japan