<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<p style="font-family:Calibri;font-size:10pt;color:#000000;margin:5pt;" align="Left">
TCS Confidential<br>
</p>
<br>
<div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof">
Dear Team,</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof">
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof">
I am new to pgpool and trying to do an HA setup of postgresql DB using pgpool.</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof">
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<span style="background-color:rgb(255, 255, 255);display:inline !important" class="ContentPasted2">For this setup I have taken three RHEL 8 servers and one elastic IP. </span>Version of postgres and pgpool is 12 and 4.2.1 respectively. </div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
I have completed the setup till starting of primary postgres and all pgpool nodes. But when I am trying to start standby postgres nodes using recovery command mentioned in section "<i>8.2.9.1. Set up PostgreSQL standby server</i>", the command execution is
getting stuck and not processing.</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<b>Command execution screenshot:</b></div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<img style="max-width:100%" class="ContentPasted6 w-810 h-63" size="6819" contenttype="image/png" data-outlook-trace="F:1|T:1" src="cid:72501fca-6a7f-4b51-96ac-c077ac6206a6"><br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<b>Log getting printed in postgres log:</b></div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1 ContentPasted3">
Password:
<div class="ContentPasted3">Password:</div>
<div class="ContentPasted3">Password:</div>
<div class="ContentPasted3">Password:</div>
<div class="ContentPasted3">Password:</div>
<div class="ContentPasted3">Password:</div>
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1 ContentPasted3">
<b class="ContentPasted4">Log getting printed in pgpool log:</b><br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1 ContentPasted3">
<span class="ContentPasted4 ContentPasted5">2022-10-25 11:42:01: pid 5677: LOG: new IPC connection received
<div class="ContentPasted5" style="">2022-10-25 11:42:11: pid 5677: LOG: new IPC connection received</div>
<div class="ContentPasted5" style="">2022-10-25 11:42:22: pid 5677: LOG: new IPC connection received</div>
<div class="ContentPasted5" style="">2022-10-25 11:42:32: pid 5677: LOG: new IPC connection received</div>
<div class="ContentPasted5" style="">2022-10-25 11:42:42: pid 5677: LOG: new IPC connection received</div>
<div class="ContentPasted5" style="">2022-10-25 11:42:52: pid 5677: LOG: new IPC connection received</div>
<div class="ContentPasted5" style="">2022-10-25 11:43:02: pid 5677: LOG: new IPC connection received</div>
</span></div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
Please suggest how to proceed with this setup.</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted1">
<br>
</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof">
I have followed below links for this configuration:</div>
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0">
<a href="https://www.pgpool.net/docs/42/en/html/example-aws.html" id="LPlnkOWALinkPreview">https://www.pgpool.net/docs/42/en/html/example-aws.html</a><br>
</div>
<div class="_Entity _EType_OWALinkPreview _EId_OWALinkPreview _EReadonly_1">
<div id="LPBorder_GTaHR0cHM6Ly93d3cucGdwb29sLm5ldC9kb2NzLzQyL2VuL2h0bWwvZXhhbXBsZS1hd3MuaHRtbA.." class="LPBorder762931" style="width: 100%; margin-top: 16px; margin-bottom: 16px; position: relative; max-width: 800px; min-width: 424px;">
<table id="LPContainer762931" role="presentation" style="padding: 12px 36px 12px 12px; width: 100%; border-width: 1px; border-style: solid; border-color: rgb(200, 200, 200); border-radius: 2px;">
<tbody>
<tr valign="top" style="border-spacing: 0px;">
<td style="width: 100%;">
<div id="LPTitle762931" style="font-size: 21px; font-weight: 300; margin-right: 8px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; margin-bottom: 12px;">
<a target="_blank" id="LPUrlAnchor762931" href="https://www.pgpool.net/docs/42/en/html/example-aws.html" style="text-decoration: none; color: var(--themePrimary);">AWS Configuration Example</a></div>
<div id="LPDescription762931" style="font-size: 14px; max-height: 100px; color: rgb(102, 102, 102); font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; margin-bottom: 12px; margin-right: 8px; overflow: hidden;">
8.3.4. Try it out. Start Pgpool-II on each server with "-n" switch and redirect log messages to the pgpool.log file. The log message of leader/active Pgpool-II node will show the message of Elastic IP assignment.. LOG: I am the cluster leader node. Starting
escalation process LOG: escalation process started with PID:23543 LOG: watchdog: escalation started Assigning Elastic IP 35.163.178.3 to ...</div>
<div id="LPMetadata762931" style="font-size: 14px; font-weight: 400; color: rgb(166, 166, 166); font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif;">
www.pgpool.net</div>
</td>
</tr>
</tbody>
</table>
<div id="LPCloseButtonContainer762931" class="uHkAz" tabindex="0" title="Remove link preview" role="button">
<i data-icon-name="Cancel" aria-hidden="true" id="LPCloseButton762931" class="Rm9Q1 root-295"></i></div>
<div id="LPCloseButtonContainer762931" class="uHkAz" tabindex="0" title="Remove link preview" role="button">
<i data-icon-name="Cancel" aria-hidden="true" id="LPCloseButton762931" class="Rm9Q1 root-295"></i></div>
<div id="LPCloseButtonContainer762931" class="uHkAz" tabindex="0" title="Remove link preview" role="button">
<i data-icon-name="Cancel" aria-hidden="true" id="LPCloseButton762931" class="Rm9Q1 root-295"></i></div>
</div>
</div>
<a href="https://www.pgpool.net/docs/42/en/html/example-cluster.html" id="LPlnkOWALinkPreview_1">https://www.pgpool.net/docs/42/en/html/example-cluster.html</a><br>
<div class="_Entity _EType_OWALinkPreview _EId_OWALinkPreview_1 _EReadonly_1">
<div id="LPBorder_GTaHR0cHM6Ly93d3cucGdwb29sLm5ldC9kb2NzLzQyL2VuL2h0bWwvZXhhbXBsZS1jbHVzdGVyLmh0bWw." class="LPBorder928698" style="width: 100%; margin-top: 16px; margin-bottom: 16px; position: relative; max-width: 800px; min-width: 424px;">
<table id="LPContainer928698" role="presentation" style="padding: 12px 36px 12px 12px; width: 100%; border-width: 1px; border-style: solid; border-color: rgb(200, 200, 200); border-radius: 2px;">
<tbody>
<tr valign="top" style="border-spacing: 0px;">
<td style="width: 100%;">
<div id="LPTitle928698" style="font-size: 21px; font-weight: 300; margin-right: 8px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; margin-bottom: 12px;">
<a target="_blank" id="LPUrlAnchor928698" href="https://www.pgpool.net/docs/42/en/html/example-cluster.html" style="text-decoration: none; color: var(--themePrimary);">Pgpool-II + Watchdog Setup Example</a></div>
<div id="LPDescription928698" style="font-size: 14px; max-height: 100px; color: rgb(102, 102, 102); font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; margin-bottom: 12px; margin-right: 8px; overflow: hidden;">
8.2. Pgpool-II + Watchdog Setup Example. This section shows an example of streaming replication configuration using Pgpool-II.In this example, we use 3 Pgpool-II servers to manage PostgreSQL servers to create a robust cluster system and avoid the single point
of failure or split brain. PostgreSQL 13 is used in this configuration example. All scripts have been tested with PostgreSQL 95 and later.</div>
<div id="LPMetadata928698" style="font-size: 14px; font-weight: 400; color: rgb(166, 166, 166); font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif;">
www.pgpool.net</div>
</td>
</tr>
</tbody>
</table>
<div id="LPCloseButtonContainer928698" class="uHkAz" tabindex="0" title="Remove link preview" role="button">
<i data-icon-name="Cancel" aria-hidden="true" id="LPCloseButton928698" class="Rm9Q1 root-295"></i></div>
<div id="LPCloseButtonContainer928698" class="uHkAz" tabindex="0" title="Remove link preview" role="button">
<i data-icon-name="Cancel" aria-hidden="true" id="LPCloseButton928698" class="Rm9Q1 root-295"></i></div>
</div>
</div>
<div class="elementToProof">
<div style="font-family: Cambria, Georgia, serif; font-size: 11pt; color: rgb(0, 36, 81);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div></div>
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div name="divtagdefaultwrapper" style="margin:0px"><font face="Cambria, serif"><span style="background-color:rgb(255,255,255)"><span id="emailGratitudeIdSpan" class="ng-binding">Thanks & Regards</span> <br>
</span><span style="background-color:rgb(255,255,255)"></span><span style="background-color:rgb(255,255,255)"><span id="firstNameSpan" class="ng-binding">Banashree</span> <span id="lastNameSpan" class="ng-binding">Biswas</span> <br>
</span></font><font face="Cambria, serif"><b><span style="background-color:rgb(255,255,255)"></span></b><span style="background-color:rgb(255,255,255)"></span><span id="addressSpan" style="background-color:rgb(255,255,255)"><span><span class="ng-binding">Tata
Consultancy Services Limited</span> <br>
</span></span><span style="background-color:rgb(255,255,255)"><span style="font-weight:bold">Mail to:</span> <span class="ng-binding" style="color:rgb(1,1,255)">banashree.biswas@tcs.com</span> </span></font></div>
</div>
</div>
</div>
</div>
</div>
<br>
<p style="font-family:Calibri;font-size:10pt;color:#000000;margin:5pt;" align="Left">
TCS Confidential<br>
</p>
<p>=====-----=====-----=====<br>
Notice: The information contained in this e-mail<br>
message and/or attachments to it may contain <br>
confidential or privileged information. If you are <br>
not the intended recipient, any dissemination, use, <br>
review, distribution, printing or copying of the <br>
information contained in this e-mail message <br>
and/or attachments to it are strictly prohibited. If <br>
you have received this communication in error, <br>
please notify us by reply e-mail or telephone and <br>
immediately and permanently delete the message <br>
and any attachments. Thank you</p>
<p></p></body>
</html>