Dockerized Python Web Application Can't Connect to PostgreSQL Database: Connection Refused Error

Hello there,

There could be a couple of issues here, but I’ll start with the most common one when dealing with Docker and databases and you can let me know how it goes.

The problem is likely that your web application is starting before your PostgreSQL database is fully ready to accept connections. Even though you’ve specified depends_on in your docker-compose.yml, this only ensures that the db service starts before the web service. It doesn’t wait for the db service to be “ready” before starting web.

To solve this issue, you can use a simple script that checks the database connection before starting your application. Here’s a simple Python script that does exactly that:

import time
import psycopg2
from psycopg2 import OperationalError

def create_conn():
    conn = None
    while not conn:
        try:
            conn = psycopg2.connect(
                dbname="mydb",
                user="myuser",
                password="mypassword",
                host="db"
            )
            print("Database connection successful")
        except OperationalError as e:
            print(e)
            time.sleep(5)
    return conn

conn = create_conn()

In this script, we’re using a while loop to try to establish a connection to the database. If it can’t connect, it will wait for 5 seconds before trying again. Once the connection is established, it will break the loop and proceed.

You can adjust this script to your needs, for instance, by limiting the number of connection attempts or increasing the sleep time.

Another approach would be to use a tool like wait-for-it or dockerize which can pause the execution of your application until the db service is ready to accept connections.

If this doesn’t solve your problem, let me know. It might be a more specific issue with your configuration or environment.

Hope that helps!