<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hello,<br>
<br>
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.<br>
<br>
Which I believe this was why, I was able to execute the script via
the command prompt, since the user is "postgres".<br>
<br>
Yes, there were errors in postgres.log, and that was how I found out
the extension was missing.<br>
<br>
Thanks for the reply.<br>
<br>
<br>
Regards,<br>
Sei Heng<br>
<br>
<br>
<div class="moz-cite-prefix">On 1/11/24 9:41 AM, Bo Peng wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAHRdu84X91GDRpJrY6qdJv7Z9jUH0EaaNXfVwh+bG_FnDsfzDA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Hi,</div>
<div><br>
</div>
<div>> However, when I execute the recovery_1st_stage script
at the command <br>
> prompt, it was able to execute successfully. <br>
</div>
<div><br>
</div>
<div>
<span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz
gmail-ChMk0b"><span class="gmail-ryNqvb">Did you see any
errors in the PostgreSQL logs?</span></span></span> <br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">2024年1月8日(月) 0:04 Ang Sei
Heng <<a href="mailto:seiheng@sendquick.com"
moz-do-not-send="true">seiheng@sendquick.com</a>>:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
Hope someone can help me out on this.<br>
<br>
I have a very weird problem with the Pgpool-II setup in my
office.<br>
<br>
Just some background, I follow the steps from the
configuration example <br>
from here: <a
href="https://www.pgpool.net/docs/latest/en/html/example-configs.html"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://www.pgpool.net/docs/latest/en/html/example-configs.html</a><br>
<br>
I manage to setup 3 nodes and able to run pcp_promote_node
to the <br>
cluster. However, when I tried to try pcp_recovery_node, it
encountered <br>
error:<br>
<br>
2024-01-05 13:02:16.233: pcp_child pid 27333: ERROR:
executing <br>
recovery, execution of command failed at "1st stage"<br>
2024-01-05 13:02:16.233: pcp_child pid 27333: DETAIL: <br>
command:"recovery_1st_stage"<br>
<br>
However, when I execute the recovery_1st_stage script at the
command <br>
prompt, it was able to execute successfully.<br>
<br>
Any suggestion I can resolve this issue?<br>
<br>
<br>
Pgpool-II: 4.5.0<br>
PostgreSQL: 15.5<br>
Linux Distro: Slackware 15<br>
<br>
<br>
<br>
Thanks,<br>
Sei Heng<br>
<br>
<br>
-- <br>
<br>
SendQuick Pte Ltd<br>
76 Playfair Road, #08-01,<br>
LHK 2 Building, Singapore 367996<br>
Tel: +65 6280 2881<br>
Fax: +65 6280 6882<br>
<br>
CONFIDENTIALITY NOTE:<br>
This email and any files transmitted with it is intended
only for the use<br>
of the person(s) to whom it is addressed,and may contain
information that<br>
is privileged, confidential and exempt from disclosure under
applicable<br>
law. If you are not the intended recipient, please
immediately notify the<br>
sender and delete the email. If you are not the intended
recipient please<br>
do not disclose, copy, distribute or take any action in
reliance on the<br>
contents of this e-mail. Thank you.<br>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank"
moz-do-not-send="true">pgpool-general@pgpool.net</a><br>
<a
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote>
</div>
</div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<p>SendQuick Pte Ltd<br>
76 Playfair Road, #08-01,<br>
LHK 2 Building, Singapore 367996<br>
Tel: +65 6280 2881<br>
Fax: +65 6280 6882</p>
<p>CONFIDENTIALITY NOTE: <br>
This email and any files transmitted with it is intended only
for the use <br>
of the person(s) to whom it is addressed,and may contain
information that <br>
is privileged, confidential and exempt from disclosure under
applicable <br>
law. If you are not the intended recipient, please immediately
notify the <br>
sender and delete the email. If you are not the intended
recipient please <br>
do not disclose, copy, distribute or take any action in reliance
on the <br>
contents of this e-mail. Thank you.</p>
</div>
</body>
</html>