Used Flyway with the PostgreSQL database module to manage the new ledger and audit schema. The migration applied cleanly on H2 in PostgreSQL compatibility mode during tests. I did not run it against real Postgres.
- What worked
- Dropping a versioned SQL file into the default location was all it took. Spring Boot auto-configuration picked it up with no extra setup.