[pgpool-general: 8992] Re: Pgpool II not able perform node recovery

[Bo Peng]

Hi,

> However, when I execute the recovery_1st_stage script at the command
> prompt, it was able to execute successfully.

Did you see any errors in the PostgreSQL logs?

2024年1月8日(月) 0:04 Ang Sei Heng <seiheng at sendquick.com>:

> Hello,
>
> Hope someone can help me out on this.
>
> I have a very weird problem with the Pgpool-II setup in my office.
>
> Just some background, I follow the steps from the configuration example
> from here: https://www.pgpool.net/docs/latest/en/html/example-configs.html
>
> I manage to setup 3 nodes and able to run pcp_promote_node to the
> cluster. However, when I tried to try pcp_recovery_node, it encountered
> error:
>
> 2024-01-05 13:02:16.233: pcp_child pid 27333: ERROR:  executing
> recovery, execution of command failed at "1st stage"
> 2024-01-05 13:02:16.233: pcp_child pid 27333: DETAIL:
> command:"recovery_1st_stage"
>
> However, when I execute the recovery_1st_stage script at the command
> prompt, it was able to execute successfully.
>
> Any suggestion I can resolve this issue?
>
>
> Pgpool-II: 4.5.0
> PostgreSQL: 15.5
> Linux Distro: Slackware 15
>
>
>
> Thanks,
> Sei Heng
>
>
> --
>
> SendQuick Pte Ltd
> 76 Playfair Road, #08-01,
> LHK 2 Building, Singapore 367996
> Tel: +65 6280 2881
> Fax: +65 6280 6882
>
> CONFIDENTIALITY NOTE:
> This email and any files transmitted with it is intended only for the use
> of the person(s) to whom it is addressed,and may contain information that
> is privileged, confidential and exempt from disclosure under applicable
> law. If you are not the intended recipient, please immediately notify the
> sender and delete the email. If you are not the intended recipient please
> do not disclose, copy, distribute or take any action in reliance on the
> contents of this e-mail. Thank you.
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240111/cf54d96c/attachment.htm>