How To Build Your Own PostgreSQL (and related software) RPMs on RHEL/Rocky/Fedora

Even though there is a wide range of RPMs for PostgreSQL and related projects in the repositories, some people don't want to use prebuilt options, or may apply some extra specific patches. Also, some companies prefer to build their packages from srpms, per their IT policy -- so they maintain their own packages.

This is very easy if you use the PostgreSQL RPM Repository infrastructure. Now, I will go over the details for it.

New repo: Extra packages for PostgreSQL RPM repo

Recently I added consul and haproxy packages to PostgreSQL RPM repository to support Patroni installations. The main motivation is to provide latest and greatest versions of these packages. However, these packages may break existing installations, like HAProxy 1.8.4 RPM on RHEL 8, where we provide 2.5.4 as of now.

So, in order not to break some users' environment, I added new repos:

How to migrate from CentOS 8 to Rocky Linux 8

NOTE: UPDATED ON 30 Nov 2021 for Rocky Linux 8.5

Rocky Linux 8.5 is released today. I already added support and wrote down instructions about how to install PostgreSQL on Rocky Linux 8, and now it is time for a short blog post about migrating from CentOS 8 to Rocky Linux 8. Please note that if you are using CentOS 8 Stream, this blog post is not suitable for you.

These steps are experimental for now -- use the instructions at your own risk. It worked for me, though.

RPM repository for unsupported PostgreSQL releases / distros

PostgreSQL RPM repository has been out for quite a long time, and we've been building packages since PostgreSQL 7.3. If you are using an unsupported PostgreSQL version or Red Hat / CentOS / Scientific Linux / Oracle Linux release for some reason and need RPMs of those releases, we have archives of them.

yum users: some -devel RPMs require a new repository

The PostgreSQL Global Development Group has released an update to all supported versions today -- so RPMs also got updated.

As of today's updates, if you are using RHEL/CentOS/OL 7, -devel subpackages in 11 and above require an extra repo to be enabled on your system for llvm and clang. Other distros and PostgreSQL versions are not affected. Please note that only -devel subpackage require this repo.

Page 1 of 8, totaling 115 entries