Advanced
PostgreSQL 16 to 17, every order kept
The shop's database must move from PostgreSQL 16 to 17 tonight. The plan in the ticket says: change the tag in compose.yaml and run docker compose up -d. Upgrade it so that every one of the 48,210 orders is still there afterwards, and the shop takes orders again.
The stack runs here with its data in the volume shop_pgdata; the orders live in the database shop. Traffic is paused while you work. Then the test places an order every minute for two hours and counts the orders: all the old ones, plus every new one the API confirmed.
What your server must hold
- No record lost
- image.dbMajor = 17
- Availability ≥ 99 %