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