BUG #12598: pgpool 9.4 broken online recovery node
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi,
On Mon, 2015-01-19 at 10:30 +0000, aromashkin@i-cb.ru wrote:
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
I think pgpool_recovery extension is missing.
CREATE EXTENSION pgpool_recovery;
should do the trick.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Hi
I'm very sorry, I discovered that the problem was CREATE EXTENSION, and
it's my fault, did not see the error message creation functions
pgpool_restore after drop functions and recall CREATE EXTENSION the
problem disappeared.
19.01.2015 18:04, Devrim Gündüz пишет:
Hi,
On Mon, 2015-01-19 at 10:30 +0000, aromashkin@i-cb.ru wrote:
in posgresql log
< 2015-01-19 13:27:25.786 MSK >ERROR: function pgpool_recovery(unknown,
unknown, unknown, unknown) does not exist at character 8I think pgpool_recovery extension is missing.
CREATE EXTENSION pgpool_recovery;
should do the trick.
Regards,
--
Ромашкин Андрей
e-mail: aromashkin@i-cb.ru
icq 895560
mob +7 (926) 295-0336
ООО "Ай-Куб"