Making use of DBA-related features

In PostgreSQL 15, a couple of developer-related features were added. Some features were also finally deprecated and have been removed from the server. In this section, we will go through the most important major changes.

Removing support for old pg_dump

One of the first things that is worth noting is that support for really old databases has been removed from pg_dump. PostgreSQL databases that are older than PostgreSQL 9.2 are not supported anymore. Considering that PostgreSQL 9.2.0 was released to the PostgreSQL community FTP server on September 10, 2012, most people should have gotten rid of their PostgreSQL 9.1 (and older) systems by now.

If you have not been able to upgrade since then, we highly recommend doing that. It is still possible to upgrade from such an old version to PostgreSQL 15. However, you will need an intermediate step and to use pg_dump twice.

Deprecating Python 2

PostgreSQL allows developers to write stored procedures...