[BUG] FATAL:  role "root" does not exist

### Bug Description

Whenever hyperswitch-pg-1 sever running in docker-compose, it though an error " role "root" does not exist"

### Expected Behavior

Error should not come.

### Actual Behavior

![Screenshot from 2024-11-14 19-27-00](https://github.com/user-attachments/assets/fc92e35a-8b2f-4023-b155-73e28ae8cf98)


### Steps To Reproduce

Provide an unambiguous set of steps to reproduce this bug. Include code or configuration to reproduce, if relevant.
1. Open Docker Desktop
2. Run hyperswitch-pg-1 server
3. After some time, you will see the error

### Context For The Bug

While setting hyperswitch on my local machine, I came across this error.

### Environment

Are you using hyperswitch hosted version? Yes/No
If yes, please provide the value of the `x-request-id` response header to help us debug your issue.

If not (or if building/running locally), please provide the following details:
1. Operating System or Linux distribution: Ubuntu 24.04
2. Rust version (output of `rustc --version`): ``: rustc 1.82.0 (f6e511eec 2024-10-15)
3. App version (output of `cargo r --features vergen -- --version`): `` NA


### Have you spent some time checking if this bug has been raised before?

- [X] I checked and didn't find a similar issue

### Have you read the Contributing Guidelines?

- [X] I have read the [Contributing Guidelines](https://github.com/juspay/hyperswitch/blob/main/docs/CONTRIBUTING.md)

### Are you willing to submit a PR?

Yes, I am willing to submit a PR!
<think>
PR Context:
- Title: fix(docker-compose): address "role root does not exist" errors arising from postgres health check
- Merged: 2024-11-19T19:04:27Z
- Files changed: 2 files
- Commits: 2 commits

Implementation approach:
## Type of Change
<!-- Put an `x` in the boxes that apply -->

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

## Description
<!-- Describe your changes in detail -->


### Additional Changes

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

<!--
Provide links to the files with corresponding ch
</think>

To implement this, you'll need to modify:


(No detailed commit information available)
{"issue_number": 6577, "pr_number": 6582, "commits_count": 0, "files_changed": 2, "response_length": 827, "file_count": 0, "needs_breakdown": false}