wait for db not work at first run compose up

[cdevacc1]

I'm noob, please explain why this happened

~/docker-django-redis-celery$ docker compose up
[+] Building 12.7s (14/14) FINISHED
=> [internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 32B 0.0s
=> [internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [internal] load metadata for docker.io/library/python:3.7-alpine 12.6s
=> [internal] load build context 0.0s
=> => transferring context: 2.04kB 0.0s
=> [1/9] FROM docker.io/library/python:3.7-alpine@sha256:d563ff4d7141b5c8d52b98039f 0.0s
=> CACHED [2/9] COPY ./requirements.txt /requirements.txt 0.0s
=> CACHED [3/9] RUN apk add --update --no-cache postgresql-client jpeg-dev 0.0s
=> CACHED [4/9] RUN apk add --update --no-cache --virtual .tmp-build-deps gcc l 0.0s
=> CACHED [5/9] RUN pip install -r /requirements.txt 0.0s
=> CACHED [6/9] RUN apk del .tmp-build-deps 0.0s
=> CACHED [7/9] RUN mkdir /app 0.0s
=> CACHED [8/9] COPY ./app /app 0.0s
=> CACHED [9/9] WORKDIR /app 0.0s
=> exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:f53fd8d9312672c13ae95a9f8922d20cc3ec926c7183b8bee6690b31 0.0s
=> => naming to docker.io/library/docker-django-redis-celery_app 0.0s
[+] Running 4/4
⠿ Network docker-django-redis-celery_default Created 0.0s
⠿ Volume "docker-django-redis-celery_data" Created 0.0s
⠿ Container docker-django-redis-celery-db-1 Created 0.0s
⠿ Container docker-django-redis-celery-app-1 Created 0.0s
Attaching to docker-django-redis-celery-app-1, docker-django-redis-celery-db-1
docker-django-redis-celery-db-1 | The files belonging to this database system will be owned by user "postgres".
docker-django-redis-celery-db-1 | This user must also own the server process.
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | The database cluster will be initialized with locale "en_US.utf8".
docker-django-redis-celery-db-1 | The default database encoding has accordingly been set to "UTF8".
docker-django-redis-celery-db-1 | The default text search configuration will be set to "english".
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | Data page checksums are disabled.
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
docker-django-redis-celery-db-1 | creating subdirectories ... ok
docker-django-redis-celery-db-1 | selecting default max_connections ... 100
docker-django-redis-celery-db-1 | selecting default shared_buffers ... 128MB
docker-django-redis-celery-db-1 | selecting default timezone ... UTC
docker-django-redis-celery-db-1 | selecting dynamic shared memory implementation ... posix
docker-django-redis-celery-db-1 | creating configuration files ... ok
docker-django-redis-celery-db-1 | running bootstrap script ... ok
docker-django-redis-celery-db-1 | performing post-bootstrap initialization ... sh: locale: not found
docker-django-redis-celery-db-1 | 2022-08-04 04:52:22.825 UTC [30] WARNING: no usable system locales were found
docker-django-redis-celery-db-1 | ok
docker-django-redis-celery-db-1 | syncing data to disk ...
docker-django-redis-celery-db-1 | WARNING: enabling "trust" authentication for local connections
docker-django-redis-celery-db-1 | You can change this by editing pg_hba.conf or using the option -A, or
docker-django-redis-celery-db-1 | --auth-local and --auth-host, the next time you run initdb.
docker-django-redis-celery-db-1 | ok
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | Success. You can now start the database server using:
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | waiting for server to start....2022-08-04 04:52:23.388 UTC [36] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.402 UTC [37] LOG: database system was shut down at 2022-08-04 04:52:23 UTC
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.406 UTC [36] LOG: database system is ready to accept connections
docker-django-redis-celery-app-1 | Traceback (most recent call last):
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
docker-django-redis-celery-app-1 | self.connect()
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
docker-django-redis-celery-app-1 | return func(*args, **kwargs)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 200, in connect
docker-django-redis-celery-app-1 | self.connection = self.get_new_connection(conn_params)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
docker-django-redis-celery-app-1 | return func(*args, **kwargs)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 187, in get_new_connection
docker-django-redis-celery-app-1 | connection = Database.connect(**conn_params)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/psycopg2/init.py", line 130, in connect
docker-django-redis-celery-app-1 | conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
docker-django-redis-celery-app-1 | psycopg2.OperationalError: connection to server at "db" (192.168.0.2), port 5432 failed: Connection refused
docker-django-redis-celery-app-1 | Is the server running on that host and accepting TCP/IP connections?
docker-django-redis-celery-app-1 |
docker-django-redis-celery-app-1 |
docker-django-redis-celery-app-1 | The above exception was the direct cause of the following exception:
docker-django-redis-celery-app-1 |
docker-django-redis-celery-app-1 | Traceback (most recent call last):
docker-django-redis-celery-app-1 | File "manage.py", line 22, in
docker-django-redis-celery-app-1 | main()
docker-django-redis-celery-app-1 | File "manage.py", line 18, in main
docker-django-redis-celery-app-1 | execute_from_command_line(sys.argv)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/management/init.py", line 419, in execute_from_command_line
docker-django-redis-celery-app-1 | utility.execute()
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/management/init.py", line 413, in execute
docker-django-redis-celery-app-1 | self.fetch_command(subcommand).run_from_argv(self.argv)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 354, in run_from_argv
docker-django-redis-celery-app-1 | self.execute(*args, **cmd_options)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 398, in execute
docker-django-redis-celery-app-1 | output = self.handle(*args, **options)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 89, in wrapped
docker-django-redis-celery-app-1 | res = handle_func(*args, **kwargs)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/management/commands/migrate.py", line 75, in handle
docker-django-redis-celery-app-1 | self.check(databases=[database])
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/management/base.py", line 423, in check
docker-django-redis-celery-app-1 | databases=databases,
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/checks/registry.py", line 76, in run_checks
docker-django-redis-celery-app-1 | new_errors = check(app_configs=app_configs, databases=databases)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/core/checks/model_checks.py", line 34, in check_all_models
docker-django-redis-celery-app-1 | errors.extend(model.check(**kwargs))
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 1303, in check
docker-django-redis-celery-app-1 | *cls._check_indexes(databases),
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/models/base.py", line 1695, in _check_indexes
docker-django-redis-celery-app-1 | connection.features.supports_covering_indexes or
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/functional.py", line 48, in get
docker-django-redis-celery-app-1 | res = instance.dict[self.name] = self.func(instance)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/postgresql/features.py", line 92, in is_postgresql_11
docker-django-redis-celery-app-1 | return self.connection.pg_version >= 110000
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/functional.py", line 48, in get
docker-django-redis-celery-app-1 | res = instance.dict[self.name] = self.func(instance)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 329, in pg_version
docker-django-redis-celery-app-1 | with self.temporary_connection():
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/contextlib.py", line 112, in enter
docker-django-redis-celery-app-1 | return next(self.gen)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 603, in temporary_connection
docker-django-redis-celery-app-1 | with self.cursor() as cursor:
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
docker-django-redis-celery-app-1 | return func(*args, **kwargs)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 259, in cursor
docker-django-redis-celery-app-1 | return self._cursor()
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 235, in _cursor
docker-django-redis-celery-app-1 | self.ensure_connection()
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
docker-django-redis-celery-app-1 | return func(*args, **kwargs)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
docker-django-redis-celery-app-1 | self.connect()
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/utils.py", line 90, in exit
docker-django-redis-celery-app-1 | raise dj_exc_value.with_traceback(traceback) from exc_value
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
docker-django-redis-celery-app-1 | self.connect()
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
docker-django-redis-celery-app-1 | return func(*args, **kwargs)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/base/base.py", line 200, in connect
docker-django-redis-celery-app-1 | self.connection = self.get_new_connection(conn_params)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
docker-django-redis-celery-app-1 | return func(*args, **kwargs)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 187, in get_new_connection
docker-django-redis-celery-app-1 | connection = Database.connect(**conn_params)
docker-django-redis-celery-app-1 | File "/usr/local/lib/python3.7/site-packages/psycopg2/init.py", line 130, in connect
docker-django-redis-celery-app-1 | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
docker-django-redis-celery-app-1 | django.db.utils.OperationalError: connection to server at "db" (192.168.0.2), port 5432 failed: Connection refused
docker-django-redis-celery-app-1 | Is the server running on that host and accepting TCP/IP connections?
docker-django-redis-celery-app-1 |
docker-django-redis-celery-db-1 | done
docker-django-redis-celery-db-1 | server started
docker-django-redis-celery-db-1 | CREATE DATABASE
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | waiting for server to shut down....2022-08-04 04:52:23.772 UTC [36] LOG: received fast shutdown request
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.775 UTC [36] LOG: aborting any active transactions
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.776 UTC [36] LOG: worker process: logical replication launcher (PID 43) exited with exit code 1
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.776 UTC [38] LOG: shutting down
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.788 UTC [36] LOG: database system is shut down
docker-django-redis-celery-app-1 exited with code 1
docker-django-redis-celery-db-1 | done
docker-django-redis-celery-db-1 | server stopped
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | PostgreSQL init process complete; ready for start up.
docker-django-redis-celery-db-1 |
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.880 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.880 UTC [1] LOG: listening on IPv6 address "::", port 5432
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.884 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.895 UTC [50] LOG: database system was shut down at 2022-08-04 04:52:23 UTC
docker-django-redis-celery-db-1 | 2022-08-04 04:52:23.899 UTC [1] LOG: database system is ready to accept connections