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

[Futureganteng]

Hello, sorry i was not familiar with postgre

i get these error when i run the docker-compose up
db_1 | 2024-04-17 22:51:02.375 BST [119] FATAL: role "root" does not exist
i logged on as root on the console

then i've logged on as admin on the website but
i get these message and the mediacms website goes down
celery_worker_1 | 2024-04-17 21:51:14,234 INFO reaped unknown pid 54 (terminated by SIGKILL)

[Nouri-redouane]

I got the same message, and i solved that by adding the following arguments to the "pg_isready" command in docker-compose.yaml file:

because the pg_isready command without -U is going to use the system user as the database user (in my case "root" because i executed docker-compose using sudo)
i got that from:
https://stackoverflow.com/questions/70205657/postgres-docker-role-root-does-not-exist