PostgreSQL versions and upgrades

Choose a version when you create a database and upgrade to a newer one from DB Settings, with a verified copy.

Updated Nov 12, 2026

Choosing a version

When you create a project or database, the picker offers PostgreSQL 14 to 18, with 17 preselected. Each server runs one major version, so a database lives on a server running its version. DB Settings and the top bar show the version your database really runs ("PG" and number); trust that over the label you picked.

Upgrade

Open Databases > DB Settings and find PostgreSQL version.
The page says This database runs PostgreSQL N. If a newer version is available in your database's region, an Upgrade to menu appears. Otherwise it says no newer version is available.
Pick the version and choose Upgrade, then confirm.

What happens: your database is copied to a server running the new version and checked row by row before anything switches. While it copies, queries wait instead of failing, then continue on the new version. If the check fails, nothing changes and the page says the last change did not complete.

Rules

Only upgrades are offered. Going to an older version is not supported.
Extensions your database uses must be available on the target. Otherwise you are told which to disable first.
Only one move can run at a time. The page shows progress.
Upgrading needs an Owner or Admin role.

Good to know

This cannot be reversed. Take a snapshot first. See Daily snapshots.
Test your app against the new version on a separate database first.
Plan for a few minutes of waiting queries on large databases.

More guides in Console: databases

Create a database

Add a PostgreSQL database to a project, choose its version and extensions, and manage several databases in one project.

Connection strings, direct and pooled connections

Find your host, port and credentials, choose between the pooled, regular and direct connection, and test that they work.

Your database's own address

Use the per-database address shown on the Connection page, what is faster about it, and how to rename it safely.

The SQL editor

Run queries and scripts against your database from the Console, use templates and history, and understand the safety limits.

Import data into a database

Bring a database over from another host, or upload a .sql or .sql.gz dump, from the Backups page.

Extensions

See which PostgreSQL extensions are available for your database, enable or disable them and understand "needs approval".