Menu

A Postgres Upgrade Is Ready When Your App Can Use the Restored Data
📰

A Postgres Upgrade Is Ready When Your App Can Use the Restored Data

DEV Community: postgres·Marcus Kim·4 days ago
#HaZC1dTQ
#devtopostgresql#devto#dev#database#restore
Reading 0:00
15s threshold

Imagine a small appointment app. You upgrade a copy of its database, the restore finishes, and the tables look right. Then the app tries to confirm an appointment and gets a permission error.

This article was prepared with AI assistance. The appointment app and rehearsal below are hypothetical.

Both observations can be true. A restored table doesn't prove that the app's database role can use it. It also doesn't prove that each customer can see only their own appointments.

On November 12, the PostgreSQL Global Development Group released PostgreSQL 14.25 and confirmed that it was the final release of version 14. If your app still runs on 14, make a plan to move to a supported major version. The plan should include a rehearsal that tests your app, not just the database tools.

Write down what the rehearsal has to prove

First confirm the version that actually serves the app. Your laptop, staging environment, and production database may all be different.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.