[pgpool-general: 9333] Re: error in first stage of recovery

[Tatsuo Ishii]

> I can spit out all the functions if you really need them (there's a LOT) but here are the ones for pgpool_recovery:

No, necessary. I just wanted to see pgpool_recover.

>  public | pgpool_recovery                           | boolean             | script_name text, remote_host text, remote_data_directory text, primary_port text, remote_node integer, remote_port text, primary_host text

Ok, you already have the correct version of pgpool_recovery
function. Is it possible you started pgpool with a schema search_path
which does not have the public schema?

BTW, are you sure that replication_mode_recovery_1st_stage.sh is the
right script for you? It's for the native replication mode, not for
the streaming replication mode.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp