Devrim's PostgreSQL Blog

If you run PostgreSQL on EC2, you've had two real choices until now: build from source, or fall back to whatever version Amazon Linux itself carries in its base repos. Neither matches what the rest of the PostgreSQL community gets from yum.postgresql.org — the full extension ecosystem, day-one minor releases, and a consistent layout across distributions.



That gap is closed. Amazon Linux 2023 is now a first-class target of the PGDG YUM repository, with its own build root and its own package tree, right next to Enterprise Linux, Fedora, and SUSE.

Summary first:

 

 

 

 

 

 

We had our first meetup on Thursday, July 2nd, organized by the community people for the community people. Bilge Korkmaz Erdim, Gülçin Yıldırım Jelínek, and I had been working on the meetup idea for a long time, and it finally came together — hosted by Microsoft Turkey at their Levent office. A big thank you to Bilge for helping organize the venue, taking care of food and drinks, and being a great host.

Today I added openSUSE Leap 16.0 support to the PostgreSQL RPM repository. Please find all details here:
https://zypp.postgresql.org/

You can find the repository RPM here: https://zypp.postgresql.org/repopackages/

This release includes all packages, including the "extras" repository.

Report any issues here: https://github.com/pgdg-packaging/pgdg-rpms/issues/new

This is an incident report, a post-mortem writeup and detailed info how we started supporting multiple RHEL minor versions.

Last month PostgreSQL RPM repos were broken for Rocky Linux and AlmaLinux 9 and 10 users due to an OpenSSL update that Red Hat pushed to versions 10.1 and 9.7, which broke backward compatibility. Actually I broke the repos.

The PostgreSQL RPM repository for SuSE Enterprise Linux has supported SLES for quite some time. We followed the usual conventions and used zypper addrepo … to add the repositories.

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:

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

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:

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

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.

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:

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!

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.

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:

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!)