<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} .ms-cui-menu {background-color:#ffffff;border:1px rgb(171, 171, 171) solid;font-family:"Microsoft YaHei UI", "Microsoft YaHei", ΢ÈíÑźÚ, SimSun, ËÎÌå, sans-serif;font-size:11pt;color:rgb(51, 51, 51);} .ms-cui-menusection-title {display:none;} .ms-cui-ctl {vertical-align:text-top;text-decoration:none;color:rgb(51, 51, 51);} .ms-cui-ctl-on {background-color:rgb(223, 237, 250);opacity: 0.8;} .ms-cui-img-cont-float {display:inline-block;margin-top:2px} .ms-cui-smenu-inner {padding-top:0px;} .ms-owa-paste-option-icon {margin: 2px 4px 0px 4px;vertical-align:sub;padding-bottom: 2px;display:inline-block;} .ms-rtePasteFlyout-option:hover {background-color:rgb(223, 237, 250) !important;opacity:1 !important;} .ms-rtePasteFlyout-option {padding:8px 4px 8px 4px;outline:none;} .ms-cui-menusection {float:left; width:85px;height:24px;overflow:hidden}--></style>
</head>
<body>
<div style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi,<br>
</p>
<p>We use the PAF (<span style="font-size: 12pt;">https://dalibo.github.io/PAF/</span><span style="font-size: 12pt;">) to manage the postgresql.</span></p>
<p><span style="font-size: 12pt;"><br>
</span></p>
<p><span style="font-size: 12pt;">According to user's requirement, we could not use trust mode in the pg_hba.conf file. So when running psql, it will ask us to input the password and we have to input the password manually.</span></p>
<p><span style="font-size: 12pt;"><br>
</span></p>
<p>So the pcs status show the following error:<br>
</p>
<div>* pgsqld_stop_0 on node1-pri 'unknown error' (1): call=34, status=complete, exitreason='Unexpected state for instance "pgsqld" (returned 1)',</div>
<div> last-rc-change='Wed Mar 6 09:09:46 2019', queued=0ms, exec=504ms<br>
</div>
<p><br>
</p>
<p><br>
</p>
<p>The cause of the error is that the PAF (/usr/lib/ocf/resource.d/heartbeat/pgsqlms) will ask to input the password and we could not pass the password to psql command in the PAF script. <br>
</p>
<p><br>
</p>
<div> exec $PGPSQL, '--set', 'ON_ERROR_STOP=1', '-qXAtf', $tmpfile,<br>
</div>
<div> '-R', $RS, '-F', $FS, '--port', $pgport, '--host', $pghost,'--username','sysdba',<br>
</div>
<div><br>
</div>
<div>Is there any way for us to pass the password to the psql command in the PAF script?<br>
</div>
<div><br>
</div>
<div>We have tried to add the "export PGPASSWORD=123456" in the /etc/profile and it does not work.<br>
</div>
<div><br>
</div>
<div>thanks<br>
</div>
<div><br>
</div>
<p><br>
</p>
<p><span style="font-size: 12pt;"><br>
</span></p>
<p><span style="font-size: 12pt;"><br>
</span></p>
<p><span style="font-size: 12pt;"><br>
</span></p>
<p><span style="font-size: 12pt;"><br>
</span></p>
</div>
</body>
</html>