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 Apr 23 '18 at 15:54
  • enterprisedb is not listed in Red hat provided packages. – Yogi Apr 23 '18 at 16:10
  • Does the RH package get the regular PostgreSQL updates? Also, does it have all the necessary extensions and other bits (apps)? – dezso Apr 23 '18 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. – Yogi Apr 23 '18 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 Apr 25 '18 at 18:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.