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

[Ang Sei Heng]

Hello,

I managed to resolve the issue. The issue is due to missing 
pgpool_recovery extension in template1 database. I believe during the 
setting up of Pgpool-II I mistakenly create extension in postgres 
database instead of template1 database.

Which I believe this was why, I was able to execute the script via the 
command prompt, since the user is "postgres".

Yes, there were errors in postgres.log, and that was how I found out the 
extension was missing.

Thanks for the reply.


Regards,
Sei Heng


On 1/11/24 9:41 AM, Bo Peng wrote:
> 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 
> <mailto: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
>     <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 <mailto:pgpool-general at pgpool.net>
>     http://www.pgpool.net/mailman/listinfo/pgpool-general
>     <http://www.pgpool.net/mailman/listinfo/pgpool-general>
>

-- 

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240111/50e059c3/attachment.htm>