Upgrades and extensions

Check the version

DB Settings > PostgreSQL version shows what the database really runs. If newer is available in its region, an Upgrade to menu appears.

Upgrade safely

1. Take an Instant Backup.
2. Confirm extensions in use exist on the target; if not, you are told which to disable.
3. Choose Upgrade and confirm.

The database is copied to a server on the new version and verified row by row. Queries wait while it copies, then continue. On failure nothing changes. You cannot go back to an older version, and only Owners and Admins can upgrade. Test on a copy first.

Extensions

In DB Settings > PostgreSQL engine & extensions, filter by Enabled, Available or Needs approval, then Enable or Disable. Disabling fails if something uses it. Some extensions are never offered on shared servers; needs approval means ask support.

Practice

Enable pg_trgm on a scratch database, create a trigram index and disable nothing in production.

Recap

• Back up, verify extensions, upgrade, test.
• Upgrades are one-way.