[scl.org] How different is rh-postgresql94 from community Postgres 94?

[Honza Horak]

The biggest differences will be visible for admin, because 
rh-postgresql95 uses concept of Software Collections 
(https://www.softwarecollections.org/en/docs/) which means binaries are 
put into alternate directory (/opt) and user needs to run `scl` command 
to adjust $PATH first:

   $ psql
   bash: psql: command not found...
   $ scl enable rh-postgresql95 bash
   $ psql
   psql: could not connect to server: No such file or directory

Also name of the service is different, rh-postgresql95 uses this name:

   systemctl status rh-postgresql95-postgresql

And location of the data is different as well, by default data files are 
located at:

   /var/opt/rh/rh-postgresql95/lib/pgsql

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.

Regards,
Honza

On 03/06/2017 12:22 PM, Aawardhan Logandan wrote:
> We install it from Upstream repository.
>
> In general what are the difference between postgresql95 and rh-postgresql95?
>
> Thanks,
> Aawardhan
>
> On Mon, Mar 6, 2017 at 3:30 PM, Honza Horak <hhorak at redhat.com
> <mailto:hhorak at redhat.com>> wrote:
>
>     Hello Aawardhan,
>
>     how do you install Postgres 9.5 in CentOS? Since it may be different
>     answer for the two cases bellow:
>
>     1) install from CentOS SCLo SIG repos:
>
>       yum install centos-release-scl-rh
>       yum install rh-postgresql95
>
>     2) install from Upstream repos:
>
>       yum install
>     https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-3.noarch.rpm
>     <https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-3.noarch.rpm>
>       yum install postgresql95-server
>
>     Honza
>
>     On 02/28/2017 06:28 AM, Aawardhan Logandan wrote:
>
>         If my product is certified to run in Postgres 9.5 (tested in
>         Cent OS),
>         can I claim that it will work in rh-postgresql95?
>
>
>         _______________________________________________
>         SCLorg mailing list
>         SCLorg at redhat.com <mailto:SCLorg at redhat.com>
>         https://www.redhat.com/mailman/listinfo/sclorg
>         <https://www.redhat.com/mailman/listinfo/sclorg>
>
>