[pgpool-general: 3725] pcp_promote problem

Janusz Borkowski janusz.borkowski at infobright.com
Tue May 19 20:22:35 JST 2015


Hi!

I see in pgpoolAdmin:

node 1 192.168.10.188 6544     Up. Disconnect. Running as standby server     postgres: Up    

Indeed, recovery.conf file exists on .188 in the PGDATA folder. This is the only running node.

However promoting is not possible:

[root at ib-wawa-189 pgpoolAdmin]# sudo -u apache /usr/bin/pcp_promote_node -g  10 localhost 9898 admin 'pgpool' 1
BackendError

in the logs:
May 19 12:35:12 localhost pgpool: 2015-05-19 12:35:12: pid 2494: FATAL:  invalid pgpool mode for the command
May 19 12:35:12 localhost pgpool: 2015-05-19 12:35:12: pid 2494: DETAIL:  specified node is already primary node, can't promote node id 1

Surely, I can promote with pg_ctl:

[root at ib-wawa-188 ~]# sudo -u postgres /usr/pgsql-9.2/bin/pg_ctl -D /var/lib/pgsql/9.2/data/ promote
server promoting

Is it a pgpool bug? I use 3.4.2-1 version.

BTW, pgpoolAdmin (pgpoolAdmin-3.4.1-2pgdg.rhel7) has a bug in php code servicing the 'Promote' button - it uses 'e1007' code for it, which resolves to "pcp_detach_node command error occurred" message.

Thanks,
JanuszB


More information about the pgpool-general mailing list