[pgpool-general: 5418] Re: pgpooladmin version issue

[Bo Peng]

Hi,

On Mon, 27 Feb 2017 17:36:10 -0500
Justin Edmands <shockwavecs at gmail.com> wrote:

> Hey pgpoolers,
> I have come across an issue that likely requires me to upgrade pgpool-II-93
> version 3.4 to 3.5.
> 
>  - After upgrading to 3.5, pgpoolAdmin status pages all show "pcp_node_info
> command error occurred."

>From Pgpool-II 3.5 the .pcppass file is required when using pgpoolAdmin.
Could you try the following steps?

  http://www.pgpool.net/docs/latest/en/html/pcp-commands.html

  -bash-4.2$ pwd
  /usr/share/httpd
  -bash-4.2$ cat .pcppass
  *:9898:postgres:postgres
  -bash-4.2$ chmod 600 .pcppass


>  - I suppose I need to upgrade pgpooladmin to show version 3.5 as the
> dropdown menu in the "pgpoolAdmin Setting" (only showed up to 3.4)

This is fixed in

  https://git.postgresql.org/gitweb/?p=pgpooladmin.git;a=commit;h=4615f807179fbfbdb18c7856e109d95f53abc201

> - Attempting to upgrade to pgpooladmin 3.5 states that I need to upgrade
> pgpool-II-93 to pg-pool-96 in order for pgpooladmin 3.5 to install.

Pgpool-II works with  pg-pool-96.
But it is recommended that you use the latest version of pgpoolAdmin 3.6.x.

> Anyways...I have postgres 9.3 data nodes. Will pgpool-II-96 have an issue
> with postgres 9.3 data nodes?


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan