[pgpool-general: 7762] Re: Pgpool-II on SLES 12.SP5 / recovery problem

Tatsuo Ishii ishii at sraoss.co.jp
Mon Oct 11 22:22:34 JST 2021


> Hi,
> 
> I am asking for help in solving the problem with starting the - Recovery option. After running options, I get an error from pgpool:
> ERROR: executing recovery, execution of command failed at "1st stage"
> 
> In the postgres logs I have:
> ERROR: function pgpool_recovery (unknown, unknown, unknown, unknown, integer) does not exist at character 8
> 
> The functions I have installed:
> # cd pgpool-recovery
> # make
> # make install
> # psql -f pgpool-recovery.sql template1 (this command was executed on all databases)
> 
> I am asking for help, what else am I missing ???

This method is obsoleted.
> # psql -f pgpool-recovery.sql template1 (this command was executed on all databases)

It is recommended to execute:

psql -c "CREATE EXTENSION pgpool_recovery"

instead (on all databases).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list