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

Joar Jegleim joar.jegleim at gmail.com
Tue May 6 17:42:23 JST 2014


On 17 April 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
> | ----

you're right of course, after fixing this in postgresql.conf the buttons work .
Thanks a lot !

>
>
>> 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



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

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


More information about the pgpool-general mailing list