Mastering PostgreSQL Databases: From Basics to Advanced/

...

/

Upgrading to a Newer Version of PostgreSQL

Upgrading to a Newer Version of PostgreSQL

Prepare and upgrade the PostgreSQL database to a newer version.

We'll cover the following...

PostgreSQL versioning

The PostgreSQL version number consists of a major, minor, and patch level. The format of the PostgreSQL version number is as follows:

Press + to interact
<major_version>.<minor_version>.<patch_level>

For example, in version 9.5.25, the major version is 9, the minor version is 5, and the patch level is 25.

  • The major version changes when there’s a significant new release, with new features and incompatible changes.

  • The minor version is incremented with every new release that’s backward compatible.

  • The patch level is incremented with every new release with bug fixes, without introducing any incompatibilities.

PostgreSQL’s versioning system provides a convenient way to keep track of new features and bug fixes in each release. It allows users to quickly determine whether an updated version of PostgreSQL includes any updates or changes that might be relevant to them. Furthermore, the version number helps to ensure that users can ...