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

Fri Apr 18 14:40:25 JST 2014

Thank you for replying me, and you're right, I haven't added the
pgpool.pg_ctl configuration directive.
I hate that I missed that part from the docs.

I'm going to look at this when I'm back from vacation next week.

Thanks !
On 17 Apr 2014 03:50, "Nozomi Anzai" <anzai at sraoss.co.jp> wrote:

> 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 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
> >
> > ----------------------
>
>
> --
> Nozomi Anzai
> SRA OSS, Inc. Japan
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140418/d2147c4c/attachment.html>