POSTGRES_USER

[kingspride]

Postgres complains about Fatal: role root does not exist when launching redash.

Adding POSTGRES_USER=postgres to the env file fixes that.

Maybe you want to add that to the setup ;)

[snickerjp]

@kingspride Thank you for reporting this issue!

The "Fatal: role root does not exist" error with PostgreSQL is indeed something that should be addressed in the setup process.

Could you provide a bit more detail about:

1. When exactly does this error occur? (during initial setup, when starting services, etc.)
2. What specific environment or conditions trigger this? (OS version, existing PostgreSQL installation, etc.)
3. Where exactly should POSTGRES_USER=postgres be added? (which env file, and any other related configuration changes needed)

Understanding the full context would help ensure we implement the right fix that works across different environments.

If you're able to create a PR with the fix, that would be fantastic! A PR would help us see the exact changes needed and test them properly.

Thank you for taking the time to identify this issue and propose a solution!