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.…