It has been a while since PostgreSQL 13 has been out, and v13 RPMs have some new features for end users. In this short blog post, I would like to summarize them:
-
Removed RHEL/CentOS 6 support
PostgreSQL 13 RPMs are not available on RHEL/CentOS 6. They have reached EOL on 30 November 2020, and I did not want to introduce another release that we have to support. Please note that I will continue building PostgreSQL RPMs for the supported versions, which is 14 Nov 2024 for v12 per
PostgreSQL website. However, I am not introducing a new package to the RHEL 6 platform. Please upgrade as soon as you can.
-
Python 3 is now the default version
I updated spec files so that Python3 is the default version, and also dropped support for PL/Python2 in the PostgreSQL 13 RPMs Fedora removed(-ish) Python 2 support as of v33, and future releases of RHEL will also follow that. RHEL 7 and 8 users still can use PL/Python2 for the previous PostgreSQL releases, but you need to migrate your functions from Python2 to Python 3 before upgrading to PostgreSQL 13. Please note that this is an RPM-only feature. PostgreSQL upstream did not remove Python2 support yet.
-
Set the default "host" auth to scram-sha-256
As of v13, the RPMs are using scram-sha-256 in postgresql.conf and pg_hba.conf. I also updated the setup script to initialize the cluster with SCRAM authentication. If you are upgrading from previous versions and not using SCRAM auth, you will need to migrate passwords as well. Jonathan Katz wrote an excellent blog post about
migrating PostgreSQL passwords from md5 to SCRAM.
-
Symlinked setup script under $PATH
PostgreSQL RPM setup script, which is under the installation directory (/usr/pgsql-13/bin/postgresql-13-setup) can now be called directly. I created a symlink under /usr/bin/ for convenience. Initializing the cluster is now easier:
postgresql-13-setup initdb
Please note that this feature is also available with the latest minor updates of v10 and above.
If you have any questions, please email to pgsql-pkg-yum@postgresql.org , or use
PostgreSQL RPM issue tracker to report problems.