fix(docker-compose): address "role root does not exist" errors arising from postgres health check

[Shark-Firewall]

Type of Change

• [ ] Bugfix
• [ ] New feature
• [ ] Enhancement
• [ ] Refactoring
• [ ] Dependency updates
• [ ] Documentation
• [ ] CI/CD

Description

Additional Changes

• [ ] This PR modifies the API contract
• [ ] This PR modifies the database schema
• [ ] This PR modifies application configuration/environment variables

Motivation and Context

Fixes #6577.

How did you test it?

Checklist

• [ ] I formatted the code cargo +nightly fmt --all
• [ ] I addressed lints thrown by cargo clippy
• [ ] I reviewed the submitted code
• [ ] I added unit tests for my changes where possible

[semanticdiff-com[bot]]

Review changes with  

[SanchithHegde]

@Shark-Firewall Can you please attach a screenshot of how you'd tested it: you can include the error being printed before and include a screenshot that no errors are being printed now?

[Shark-Firewall]

Before changes:

After changes: