Upgrading Your Render Postgres Version

Upgrading your database requires downtime. Schedule upgrades accordingly.

You can upgrade your Render Postgres database to a more recent major version of PostgreSQL in one of the following ways:

• Perform an in-place upgrade
  • This method always upgrades to the latest major version supported by Render (currently 18).
• Create a new database and migrate your data
  • This method enables you to upgrade to any major version supported by Render.

Version support

^{*Only workspaces with an existing database on PostgreSQL 11 or 12 can create new databases on the corresponding version.}

View your database's current version from its Info page in the Render Dashboard:

Upgrading in-place

Render supports in-place database upgrades to PostgreSQL 18 from any previous version.

1. Perform a test upgrade (recommended)

Before you upgrade, we strongly recommend creating a temporary copy of your database and performing a test upgrade on the copy. This way, you can:

• Confirm that your database will upgrade successfully
• Estimate how long your database upgrade will take

1. In the Render Dashboard, go to your database's Info page and click its current version:

   

   The following page appears with recommended upgrade steps:

   

   Don't see the "Clone this database" button?

   This means that your database uses a legacy instance type that doesn't have point-in-time recovery (PITR) enabled. Render uses PITR to create your database copy.

   To enable PITR, you can move your database to a flexible plan by changing its compute plan.

   We strongly recommend that you enable PITR for any database before you upgrade it in-place, so that you can copy it for testing.

2. Click Clone this database. Render immediately creates a new database and starts replicating the primary database's state from ten minutes earlier.

   • The clone will not reflect any changes made to the primary database after the restore point.

3. Click View PostgreSQL clone to jump to the clone's upgrade page:

   

   You can't upgrade the clone until data replication completes.

4. When the Upgrade to PostgreSQL 18 button becomes active, click it to kick off the clone's in-place upgrade.

   A log explorer appears and displays log entries from the upgrade process. Depending on the size of your database, the upgrade process might take up to one hour.

   Note the total duration of the test upgrade, which provides a helpful estimate for the primary database upgrade.

5. When the upgrade completes, the clone's status changes from Upgrading to Available. You can now run commands on the upgraded clone to confirm that it behaves as expected.

   If the upgrade fails, the clone remains on its original PostgreSQL version.

   Review the logs to identify any issues. If the underlying cause or resolution is unclear, reach out to support in the Render Dashboard.

6. When you're done testing the clone, you can delete it from its Info page.

2. Upgrade your database

After you perform a successful