1014 B
1014 B
Verify Postgres Bump & System Health
I will verify the system works after the Postgres version bump by resetting the environment and running the integration test suite.
Execution Steps
-
Reset Docker Environment:
docker-compose down -vto remove existing containers and incompatible volumes.docker-compose up -dto start fresh with Postgres 17.- Wait for services to initialize.
-
Initialize Database:
- Apply all migrations from
migrations/*.sqltomadbase_db. - Apply test schema from
tests/integration/setup_db.sqltomadbase_db. - This will be done by piping the SQL files into
docker exec -i madbase_db psql -U postgres -d postgres.
- Apply all migrations from
-
Run Integration Tests:
- Execute
npm testinsidetests/integration. - This will run the Vitest suite covering Auth, Storage, Realtime, Functions, and Data API.
- Execute
Expected Outcome
- All tests should pass if the Postgres 17 upgrade is compatible and the system is healthy.