Re: rh-postgresql96 vs community postgresql-9.6

On 04/24/2018 10:06 PM, Adrian Klaver wrote:
> On 04/23/2018 08:59 AM, yogeshr wrote:
(...)
>> 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.

Indeed; the RedHat packages seem to use a completely different file system layout
to the community packages, so many if not most community packages are unlikely
to work even if force-installed.

>> 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.

Other possibilities would be: a) compile the package from source
(not an efficient method of deployment, not desirable to do on production
machines and often not possible), b) create your own RPMs compatible with
the RedHat ones (community spec files are available here:
https://git.postgresql.org/gitweb/?p=pgrpms.git ), or c) persuade your
client to switch to a support provider who provides support based
around community packages (there are a number, including the one mentioned
in my email signature).

Regards

Ian Barwick

--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services