BUG #12598: pgpool 9.4 broken online recovery node - Mailing list pgsql-bugs

From aromashkin@i-cb.ru
Subject BUG #12598: pgpool 9.4 broken online recovery node
Date
Msg-id 20150119103038.1983.21759@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12598: pgpool 9.4 broken online recovery node
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12598
Logged by:          Andrey Romashkin
Email address:      aromashkin@i-cb.ru
PostgreSQL version: 9.4.0
Operating system:   Centos 7
Description:

After upgrage pgpool to 9.4 with postgresql and on clean installation.

if start recoveru failed node /usr/pgpool-9.4/bin/pcp_recovery_node -d 60
localhost 9898 user pass 1

DEBUG: send: tos="R", len=46
DEBUG: recv: tos="r", len=21, data=AuthenticationOK
DEBUG: send: tos="D", len=6
DEBUG: recv: tos="e", len=20, data=recovery failed
DEBUG: command failed. reason=recovery failed
BackendError
DEBUG: send: tos="X", len=4


in posgresql log
< 2015-01-19 13:27:25.786 MSK >ERROR:  function pgpool_recovery(unknown,
unknown, unknown, unknown) does not exist at character 8
< 2015-01-19 13:27:25.786 MSK >HINT:  No function matches the given name and
argument types. You might need to add explicit type casts.
< 2015-01-19 13:27:25.786 MSK >STATEMENT:  SELECT
pgpool_recovery('recoveryst1', 'db-node2', '/var/lib/pgsql/9.4/data',
'5432')

pgpool installed from yum.postgresql.org

pgsql-bugs by date:

Previous
From: Tomonari Katsumata
Date:
Subject: Re: BUG #12584: small bug about estimation of rows
Next
From: alanm@cc.hawaii.edu
Date:
Subject: BUG #12571: Web site documentation error for make_timestamp