Devrim Gunduz's PostgreSQL Blog

Improved aarch64 (arm64) support is available in the PostgreSQL RPM repository.

Posted by Devrim Gunduz on Wednesday, November 16. 2022

The PostgreSQL RPM repository has included aarch64 support for a couple of years, however it was limited (like lack of packages, maintenance issues, etc).

Thanks to the PostgreSQL.org sysadmins team, along with the new and shiny build servers, aarch64 support is now improved. Here are the changes:

Pagila 3.0.0 is out with shiny new features and bugfixes

Posted by Devrim Gunduz on Thursday, July 28. 2022

I just released Pagila 3.0.0, with some new shiny features:

How to install PostgreSQL and PostGIS on Rocky Linux 9

Posted by Devrim Gunduz on Wednesday, July 27. 2022

Rocky Linux 9 is finally out. Some repo names changed, so here is a short guide about installing PostgreSQL and PostGIS on Rocky Linux 9:

How to install PostgreSQL 14, 13, 12, 11 and 10 to Red Hat Enterprise Linux 9

Posted by Devrim Gunduz on Thursday, May 19. 2022

Red Hat Enterprise Linux 9 is out. RPMs are already out even since 9.0 beta was announced.

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

Posted by Devrim Gunduz on Wednesday, March 30. 2022

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

Posted by Devrim Gunduz on Wednesday, March 16. 2022

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:

Installing PostgreSQL 14 beta/RC on RHEL / Rocky Linux / Fedora and SLES

Posted by Devrim Gunduz on Friday, June 25. 2021

PostgreSQL 14 beta 2 is released. As written in the announcement, "In the spirit of the open source PostgreSQL community, we strongly encourage you to test the new features of PostgreSQL 14 in your systems to help us eliminate bugs or other issues that may exist."

So, let's install it!

How to migrate from CentOS 8 to Rocky Linux 8

Posted by Devrim Gunduz on Monday, June 21. 2021

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.

CVE-2021-20271 and PostgreSQL YUM/DNF repo

Posted by Devrim Gunduz on Thursday, May 6. 2021

Recently I received a report about a flaw in RPM's signature check functionality when reading a package file.

To fix this issue, I built and released new repository RPMs for the following platforms:

How to install PostgreSQL 13, 12, 11, 10 and 9.6 to Rocky Linux 8

Posted by Devrim Gunduz on Wednesday, May 5. 2021

Rocky Linux 8 RC is out. This is a great step for the final release. Rocky Linux is a "community enterprise operating system designed to be 100% bug-for-bug compatible with Red Hat Enterprise Linux". Thus, PostgreSQL packages built for RHEL will also work on Rocky Linux 8 (and already verified this!)

Running multiple instances of the same PostgreSQL version on RHEL/CentOS 7/8 and Fedora

Posted by Devrim Gunduz on Friday, February 12. 2021

In this blog post, I'll show you how to run multiple instances of the same PostgreSQL version on RHEL/CentOS 7/8 and Fedora.

This blog post assumes that PostgreSQL is installed using the PostgreSQL RPM repository as described in here.

Announcing PostgreSQL RPM repository for RHEL 8 - ppc64le

Posted by Devrim Gunduz on Thursday, January 7. 2021

I added RHEL 8 - ppc64le support to PostgreSQL YUM repo for all the supported PostgreSQL versions as of today.

To use the repo and install PostgreSQL on this platform, please follow these steps:

RPM repository for unsupported PostgreSQL releases / distros

Posted by Devrim Gunduz on Monday, December 28. 2020

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.

LLVM issues with PostgreSQL YUM repository on CentOS 8

Posted by Devrim Gunduz on Friday, December 25. 2020

In the latest 3 minor releases of Red Hat Enterprise Linux 8, Red Hat have broken LLVM compatibility with the previous minor releases (like introducing LLVM 8 with RHEL 8.1, LLVM 9 with RHEL 8.2, and LLVM 10 with RHEL 8.3).

Installing PostGIS 3.1 and PostgreSQL 13 on CentOS 8

Posted by Devrim Gunduz on Thursday, December 24. 2020

Installing PostGIS 3.1 on CentOS 8 requires a few steps: