Our client has provided us Red Hat machine for setting up PostgreSQL. We are allowed to install red hat provided packages only.

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?

Also, we are trying to set up repmgr for this PostgreSQL in the local environment but we didn't find any suitable package for this PostgreSQL.

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

any help would be appreciated.

  • Have you looked at: enterprisedb?
    – McNets
    Commented Apr 23, 2018 at 15:54
  • enterprisedb is not listed in Red hat provided packages.
    – YogeshR
    Commented Apr 23, 2018 at 16:10
  • Does the RH package get the regular PostgreSQL updates? Also, does it have all the necessary extensions and other bits (apps)? Commented Apr 23, 2018 at 17:10
  • it does have all necessary extensions but I am not sure about compatibility with other open source tools present for community PostgreSQL.
    – YogeshR
    Commented Apr 23, 2018 at 19:45
  • 1
    I would think it is compatible with other open source tools. Redhat is just packaging the software, not forking it entirely. But it doesn't matter if those tools are compatible, if your client won't let you use them.
    – jjanes
    Commented Apr 25, 2018 at 18:00


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.