[pgpool-general: 9334] 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

Sorry I meant PostgreSQL, not pgpool since pgpool_recovery is executed
by PostgreSQL.

> 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