[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