Re: rh-postgresql96 vs community postgresql-9.6 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: rh-postgresql96 vs community postgresql-9.6
Date
Msg-id 66ca8c57-83d7-75c6-3bea-9355aa237223@aklaver.com
Whole thread Raw
In response to rh-postgresql96 vs community postgresql-9.6  (yogeshr <yogesh.rathore@decurtis.com>)
Responses Re: rh-postgresql96 vs community postgresql-9.6
List pgsql-general
On 04/23/2018 08:59 AM, yogeshr wrote:
> Our client has provided us Red Hat machine for setting up PostgreSQL. We are
> allowed to install red hat provided packages only.

What version of RH?

> 
> So we have to install red hat provided postgresql (rh-postgresql96) instead
> of postgresql-9.6.
> 
> Is it a good approach to go with red hat specific PostgreSQL in production
> instead of community PostgreSQL?

It is the same code so that should not be a problem. The issues would be 
support and version life:

So do you have RH support for longer then 5 years of community support 
for a version?

Will you be able to upgrade to new version in future?

> Also, we were trying to set up repmgr for this PostgreSQL in the local
> environment but we didn't find any suitable package for this PostgreSQL.
That is something you are going to have to talk over with your client. A 
RH-provided package only policy is going to prevent them from 
participating in the diverse third party package community that exists 
around Postgres.


> 
> How can we install any high availability solution like repmgr for Red Hat
> provided PostgreSQL?

That is probably some you will have to discuss with RH.

> 
> any help would be appreciated.
> 
> 
> 
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Questions on user defined data types
Next
From: Igor Neyman
Date:
Subject: RE: Strange error in Windows 10 Pro