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

[Tatsuo Ishii]

> Ok, some progress:
> 
> I had not installed the pgpool_recovery extension on the template1 database. I assume it must operate out of that database in order to work? I don't see any configuration parameter to specify a different database in pgpool.conf.

The database name "template1" is fixed. There's no "recovery_database"
parameter in pgpool.conf.

> Installing the extension got me to this error:
> < usr:repl host:10.6.1.191 time:2025-02-06 14:14:38.616 EST 42501 pid:2574580 >ERROR:  must be superuser to use pgpool_recovery function
> It seems that the recovery user should not be "repl" with only the replication privilege.
> 
> Changed that parameter in pgpool.conf:
>  recovery_user = 'postgres'
> 
> Restarted, then ran pcp_recovery_node again:
> 
> sh: /opt/data/data15_new//etc/pgpool-II/scripts/recovery_1st_stage.sh: No such file or directory
> 
> /opt/data/data15_new is the home directory for my database. I have not installed any pgpool code yet on the database nodes themselves.

You need to copy /etc/pgpool-II/scripts/recovery_1st_stage.sh into
/opt/data/data15_new, and set "recovery_1st_stage_command =
recovery_1st_stage.sh".

> All the load balancing configuration has been done on a separate instance.  My plan has been to have three machines with pgpool on them and then two database nodes on separate machines. I had assumed that pgpool would be the thing running the scripts, so I had set up certificate-based logins on the pgpool node to the databases, It sounds like what I actually need to do is to install the scripts in a subdirectory of the postgres instance, then set up certificate-based passwordless logins between the database nodes. Is this correct?

Yes, it's correct.

BTW, if you have not read the step-by-step installtion manual coming
with Pgpool-II yet, I strongly recommend you to read it.

https://www.pgpool.net/docs/latest/en/html/example-cluster.html

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