celery cannot connect to postgresql

[rashidiy]

what is wrong?

my postgresql database incide docker

my celery.py

from celery import Celery

os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'root.settings')

background_worker = Celery('root')
background_worker.conf.broker_connection_retry_on_startup = True
background_worker.config_from_object('django.conf:settings', namespace='CELERY')
background_worker.autodiscover_tasks()

[auvipy]

you are trying to use a discontinued package.

[rashidiy]

@auvipy which package discounted?

[amirhosein-kia-darbandsary]

Why is this code (os.environ.setdefault) not enough?

This code only specifies the path to the Django settings, but:

1. If the database settings in settings.py depend on environment variables (e.g., DB_NAME, DB_USER, etc.), these variables must be present in the environment where Celery is running.
2. If these variables are not defined in the environment where Celery is running, Celery will not be able to connect to the database.

---

Final Solution:

1. Ensure that all required environment variables (e.g., DB_NAME, DB_USER, DB_PASSWORD, etc.) are defined in docker-compose.yml for the celery service.
2. If you are not using Docker, make sure these variables are defined in the environment where Celery is running (e.g., in the operating system or in a .env file).
3. If you are using django-environ or similar libraries, ensure that the .env file is loaded correctly.

P.s

I've this problem for the celery-beat too so don't forget.

sample

  celery_worker_web:
    build: .
    container_name: celery_worker_web
    depends_on:
      - web
    environment:
      - CELERY_BROKER_URL=${CELERY_BROKER_URL}
      - CELERY_RESULT_BACKEND=${CELERY_RESULT_BACKEND}
      - POSTGRES_DB=${POSTGRES_DB}
      - POSTGRES_USER=${POSTGRES_USER}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}