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

[Adam Blomeke]

>> 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?
Not from what I can tell:
[postgres@####### ~]$ psql -p 5433 #####
psql (15.10)
Type "help" for help.

#####=# show search_path;
   search_path
-----------------
 "$user", public
(1 row)

> 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.

Ah, now here you may have me. I am using streaming replication mode, so should I be using recovery_1st_stage.sh instead? Will that have an impact on the pcp command?

-----Original Message-----
From: Tatsuo Ishii <ishii at postgresql.org> 
Sent: Tuesday, February 4, 2025 21:20
To: Adam Blomeke <adam.blomeke at volanno.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 9333] Re: error in first stage of recovery

[You don't often get email from ishii at postgresql.org. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

>> 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