The planned database migration for the Potato Energy project is complete. The transition was performed without data loss and with minimal downtime.
What changed
| Service | Before | After | Reason |
|---|---|---|---|
| Authelia | PostgreSQL 15.x | PostgreSQL 18.x | Required for new authentication features and improved security |
| Mastodon | PostgreSQL 15.x | PostgreSQL 18.x | Support for modern ActivityPub versions and better federation performance |
| Nextcloud | PostgreSQL 15.x | PostgreSQL 17.x | Stable branch with long-term support and compatibility with current plugins |
💡 PostgreSQL 18 was released on September 25, 2025. It brings improved I/O performance, enhanced partitioning capabilities, and an updated query planner.
How the migration was performed
- Logical backup —
pg_dumpallfor all databases - Physical volume archive — a safety copy of raw data
- Deployment of new containers — with updated images
- Data restoration —
psql < pg_dumpall.sql - Verification — checking versions, paths, and table integrity
The full process is described in the technical article: PostgreSQL in Docker: Major Version Migration Without Data Loss