<div dir="ltr">Thanks a lot !! that was helpful.</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Mar 6, 2017 at 5:01 PM, Honza Horak <span dir="ltr"><<a href="mailto:hhorak@redhat.com" target="_blank">hhorak@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The biggest differences will be visible for admin, because rh-postgresql95 uses concept of Software Collections (<a href="https://www.softwarecollections.org/en/docs/" rel="noreferrer" target="_blank">https://www.softwarecollectio<wbr>ns.org/en/docs/</a>) which means binaries are put into alternate directory (/opt) and user needs to run `scl` command to adjust $PATH first:<br>
<br>
  $ psql<br>
  bash: psql: command not found...<br>
  $ scl enable rh-postgresql95 bash<br>
  $ psql<br>
  psql: could not connect to server: No such file or directory<br>
<br>
Also name of the service is different, rh-postgresql95 uses this name:<br>
<br>
  systemctl status rh-postgresql95-postgresql<br>
<br>
And location of the data is different as well, by default data files are located at:<br>
<br>
  /var/opt/rh/rh-postgresql95/li<wbr>b/pgsql<br>
<br>
As for the feature set and usage from remote server, I don't think there are any differences, so applications won't see any difference IMO.<br>
<br>
Regards,<br>
Honza<span class=""><br>
<br>
On 03/06/2017 12:22 PM, Aawardhan Logandan wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
We install it from Upstream repository.<br>
<br>
In general what are the difference between postgresql95 and rh-postgresql95?<br>
<br>
Thanks,<br>
Aawardhan<br>
<br>
On Mon, Mar 6, 2017 at 3:30 PM, Honza Horak <<a href="mailto:hhorak@redhat.com" target="_blank">hhorak@redhat.com</a><br></span><span class="">
<mailto:<a href="mailto:hhorak@redhat.com" target="_blank">hhorak@redhat.com</a>>> wrote:<br>
<br>
    Hello Aawardhan,<br>
<br>
    how do you install Postgres 9.5 in CentOS? Since it may be different<br>
    answer for the two cases bellow:<br>
<br>
    1) install from CentOS SCLo SIG repos:<br>
<br>
      yum install centos-release-scl-rh<br>
      yum install rh-postgresql95<br>
<br>
    2) install from Upstream repos:<br>
<br>
      yum install<br>
    <a href="https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-3.noarch.rpm" rel="noreferrer" target="_blank">https://download.postgresql.or<wbr>g/pub/repos/yum/9.5/redhat/rhe<wbr>l-7-x86_64/pgdg-centos95-9.5-<wbr>3.noarch.rpm</a><br>
    <<a href="https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-3.noarch.rpm" rel="noreferrer" target="_blank">https://download.postgresql.o<wbr>rg/pub/repos/yum/9.5/redhat/rh<wbr>el-7-x86_64/pgdg-centos95-9.5-<wbr>3.noarch.rpm</a>><br>
      yum install postgresql95-server<br>
<br>
    Honza<br>
<br>
    On 02/28/2017 06:28 AM, Aawardhan Logandan wrote:<br>
<br>
        If my product is certified to run in Postgres 9.5 (tested in<br>
        Cent OS),<br>
        can I claim that it will work in rh-postgresql95?<br>
<br>
<br>
        ______________________________<wbr>_________________<br>
        SCLorg mailing list<br></span>
        <a href="mailto:SCLorg@redhat.com" target="_blank">SCLorg@redhat.com</a> <mailto:<a href="mailto:SCLorg@redhat.com" target="_blank">SCLorg@redhat.com</a>><br>
        <a href="https://www.redhat.com/mailman/listinfo/sclorg" rel="noreferrer" target="_blank">https://www.redhat.com/mailman<wbr>/listinfo/sclorg</a><br>
        <<a href="https://www.redhat.com/mailman/listinfo/sclorg" rel="noreferrer" target="_blank">https://www.redhat.com/mailma<wbr>n/listinfo/sclorg</a>><br>
<br>
<br>
</blockquote>
</blockquote></div><br></div>