In-Place Upgrade

What This Does

This service automatically upgrades your PostgreSQL database to a newer Major version. It handles all the complex technical steps for you, keeps your data safe with automatic backups, and rolls back automatically if something goes wrong.

Important to Know

• Downtime Required: Your database will be unavailable during the upgrade
• Duration: Depends on database size (small databases = minutes, large databases = hours)
• Access Blocked: Incoming connections are temporarily blocked during the process
• Automatic Process: Once started, everything runs automatically

How It Works

Step 1: Preparation

• System checks if the upgrade is possible (precheck)
• Creates a complete backup of your database
• Blocks incoming connections

Step 2: Upgrade Process

For primary databases:

• Uses pgautoupgrade to migrate your data
• Upgrades the PostgreSQL software
• Your data is transferred to the upgraded version

If you have read replicas:

• Only the main database gets upgraded
• Read replicas are rebuilt fresh and automatically sync

Step 3: Completion

• Verifies everything works
• Re-enables connections
• Your database is now upgraded

If Something Goes Wrong

If an error occurs, your database is automatically restored from backup and returned to the state before the upgrade. Your data is always protected.

After the Upgrade

Test your application to ensure everything works as expected. Your database is now running the newer version with all your data preserved.