<div dir="ltr">Hi Peng,<br><br><div class="gmail_quote"><div dir="ltr">On Thu, Nov 15, 2018 at 8:30 AM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi usama,<br>
<br>
I think you downloaded the pgpool rpms from pgdg repository.<br>
<br>
-----<br>
# wget <a href="https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgpool-II-10-4.0.1-1.rhel6.x86_64.rpm" rel="noreferrer" target="_blank">https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgpool-II-10-4.0.1-1.rhel6.x86_64.rpm</a><br>
# rpm -plq pgpool-II-10-4.0.1-1.rhel6.x86_64.rpm | grep pg_enc<br>
/usr/pgpool-10/bin/pg_enc<br></blockquote><div><br></div><div>Yes I guess so,</div><div>This is what I have done.</div><div><br></div><div><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:13px;line-height:normal;color:rgb(0,0,0)"><span class="gmail-s1" style="font-variant-ligatures:no-common-ligatures"><font face="monospace, monospace">rpm -Uvh <a href="https://yum.postgresql.org/${PGMAJOR}/redhat/rhel-6-x86_64/pgdg-redhat10-10-2.noarch.rpm">https://yum.postgresql.org/${PGMAJOR}/redhat/rhel-6-x86_64/pgdg-redhat10-10-2.noarch.rpm</a></font></span></p></div><div><font face="monospace, monospace"><span style="color:rgb(0,0,0);font-size:13px;font-variant-ligatures:no-common-ligatures">yum -y install</span><span style="font-size:13px;color:rgb(0,0,0);font-variant-ligatures:no-common-ligatures"> pgpool-II-10-</span><span style="font-size:13px;color:rgb(0,0,0);font-variant-ligatures:no-common-ligatures">4.0.1</span> </font></div><div><br></div><div>All pgpool binaries including pg_md5 and all pcp_* utilities have symlinks in '/usr/bin' directory but pg_enc's is missing</div><div>e.g.</div><font face="monospace, monospace">/usr/bin/pg_md5 -> /etc/alternatives/pgpool-pg_md5 -> /usr/pgpool-10/bin/pg_md5</font><div><br></div><div>Thanks</div><div>Best Regards</div><div>Muhammad Usama</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
------<br>
<br>
On Thu, 15 Nov 2018 11:46:36 +0900<br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> wrote:<br>
<br>
> Hi usama,<br>
> <br>
> I tried to install Pgpool 4.0.1 for PG V10 on centos 6.<br>
> But it seems pg_enc is correctly installed in /usr/bin/.<br>
> <br>
> Did you miss something?<br>
> <br>
> ------------------------<br>
> # wget <a href="http://www.pgpool.net/yum/rpms/4.0/redhat/rhel-6-x86_64/pgpool-II-pg10-4.0.1-1pgdg.rhel6.x86_64.rpm" rel="noreferrer" target="_blank">http://www.pgpool.net/yum/rpms/4.0/redhat/rhel-6-x86_64/pgpool-II-pg10-4.0.1-1pgdg.rhel6.x86_64.rpm</a><br>
> <br>
> # cat /etc/redhat-release <br>
> CentOS release 6.10 (Final)<br>
> <br>
> # rpm -ivh pgpool-II-pg10-4.0.1-1pgdg.rhel6.x86_64.rpm <br>
> warning: pgpool-II-pg10-4.0.1-1pgdg.rhel6.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 60ae0e48: NOKEY<br>
> Preparing... ########################################### [100%]<br>
> 1:pgpool-II-pg10 ########################################### [100%]<br>
> <br>
> <br>
> # which pg_enc<br>
> /usr/bin/pg_enc<br>
> <br>
> # ll /usr/bin/pg_enc <br>
> -rwxr-xr-x. 1 root root 109168 Oct 31 09:52 /usr/bin/pg_enc<br>
> ---------------------------<br>
> <br>
> <br>
> On Wed, 14 Nov 2018 18:05:19 +0500<br>
> Muhammad Usama <<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>> wrote:<br>
> <br>
> > Hi<br>
> > I have looked into this again. and seems like the pg_enc is actually<br>
> > installed but unlike other pgpool utilities it is not present in /usr/bin/<br>
> > directory<br>
> > pg_enc after installation is located in /usr/pgpool-10/bin/pg_enc directory<br>
> > <br>
> > Thanks<br>
> > Best Regards<br>
> > Muhammad Usama<br>
> > <br>
> > <br>
> > On Wed, Nov 14, 2018 at 5:40 PM Muhammad Usama <<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>> wrote:<br>
> > <br>
> > > Hi peng,<br>
> > ><br>
> > > I installed the Pgpool-II 4.0.1 rpm for PG V10 on centos 6 and<br>
> > > apparently the RPM does not install the pg_enc utility added in Pgpool-II<br>
> > > V4.0.<br>
> > ><br>
> > ><br>
> > > Thanks<br>
> > > Best Regards<br>
> > > Muhammad Usama<br>
> > ><br>
> > ><br>
> > ><br>
> > ><br>
> <br>
> <br>
> -- <br>
> Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> SRA OSS, Inc. Japan<br>
> <br>
> _______________________________________________<br>
> pgpool-hackers mailing list<br>
> <a href="mailto:pgpool-hackers@pgpool.net" target="_blank">pgpool-hackers@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
> <br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
</blockquote></div></div>