Can't reset postgres Db password

changing the default db password in the docker-compose.yml gives the following error up on running docker compose up -d with docker status as unhealthy

2024-08-15 03:26:27 ERROR      setup           Exception!

    Traceback (most recent call last):
      File "/backend/setup/__main__.py", line 42, in wait_for_postgres
        await Postgres.connect()
      File "/backend/ayon_server/lib/postgres.py", line 89, in connect
        cls.pool = await asyncpg.create_pool(
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/local/lib/python3.11/site-packages/asyncpg/pool.py", line 403, in _async__init__
        await self._initialize()
      File "/usr/local/lib/python3.11/site-packages/asyncpg/pool.py", line 430, in _initialize
        await first_ch.connect()
      File "/usr/local/lib/python3.11/site-packages/asyncpg/pool.py", line 128, in connect
        self._con = await self._pool._get_new_connection()
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/local/lib/python3.11/site-packages/asyncpg/pool.py", line 502, in _get_new_connection
        con = await connection.connect(
              ^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/local/lib/python3.11/site-packages/asyncpg/connection.py", line 2329, in connect
        return await connect_utils._connect(
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/local/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 991, in _connect
        conn = await _connect_addr(
               ^^^^^^^^^^^^^^^^^^^^
      File "/usr/local/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 828, in _connect_addr
        return await __connect_addr(params, True, *args)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/local/lib/python3.11/site-packages/asyncpg/connect_utils.py", line 876, in __connect_addr
        await connected
    asyncpg.exceptions.InvalidPasswordError: password authentication failed for user "ayon"

I’m able to change the DB password manually within the postgress container, but after a container restart ynput/ayon:latest goes unhealthy