madbase/.trae/documents/plan_20260311_231329.md

Bump Postgres Version to 17

I will upgrade the Postgres version from 15-alpine to 17-alpine in docker-compose.yml.

Changes

• File: docker-compose.yml
• Action: Update image: postgres:15-alpine to image: postgres:17-alpine for both the db (Tenant DB) and control_db (Control Plane DB) services.

Important Note on Data

• Volume Incompatibility: Postgres data directories are version-specific. Upgrading the major version (15 -> 17) means the existing data in madbase_db_data and madbase_control_db_data volumes will not be compatible.
• Resolution: You will likely need to delete the existing volumes (docker-compose down -v) and let them be recreated, or perform a manual dump/restore if you have critical data.

Execution Steps

1. Update docker-compose.yml: Change the image tag.
2. Verify: I will check the file content after the update.