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

[Aawardhan Logandan]

Thanks a lot !! that was helpful.

On Mon, Mar 6, 2017 at 5:01 PM, Honza Horak <hhorak at redhat.com> wrote:

> The biggest differences will be visible for admin, because rh-postgresql95
> uses concept of Software Collections (https://www.softwarecollectio
> ns.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/rhe
>> l-7-x86_64/pgdg-centos95-9.5-3.noarch.rpm
>>     <https://download.postgresql.org/pub/repos/yum/9.5/redhat/rh
>> el-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>
>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/sclorg/attachments/20170306/e3722a2e/attachment.htm>