Skip to content

What is new in PostgreSQL 13 RPMs?

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.

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

Form options

Submitted comments will be subject to moderation before being displayed.