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