Postgresql Upgrade 14 to 18
PostgreSQL 14 is approaching the end of its support life, so now is a good time to plan your next major-version upgrade. In this guide, we will walk through a PostgreSQL 14 to PostgreSQL 18 upgrade on Ubuntu, from the initial health checks and backup to migration, validation and cleanup. The procedure uses Ubuntu's pg_upgradecluster utility, which runs PostgreSQL's pg_upgrade process underneath. The example assumes that PostgreSQL 14 is installed as the 14/main cluster and that PostgreSQL 18 packages are available from the official PostgreSQL APT repository. Environment covered in this guide Source: PostgreSQL 14, cluster 14/main Target: PostgreSQL 18 Operating system: Ubuntu 22.04, 24.04 or 26.04 Upgrade method: pg_upgradecluster -m upgrade (copy mode) Downtime: required while applications are stopped and the upgrade is performed Important: Test the complete procedure on a staging copy before using it ...