Postgres 17 migration

Web dashboard v2.31.0 requires Postgres 17. Please follow this guide after upgrading to version v2.31.0 or above.

1. Backup your database

docker exec postgres pg_dumpall -U postgres > ~/backup.sql

2. Update gamebench.toml

Set postgresHost to postgres17

3. Re-generate configuration

./gbctl generate-config --no-interaction

4. Restart containers

docker-compose up -d

5. Load data into Postgres 17 database

docker exec -i postgres17 psql -U postgres < ~/backup.sql