docker-compose does not start postgres

Question

I m creating a docker-compose config for an django app, the Dockerfile builds successfully but when I compose them up, django return an issue -- cannot connect to postgres.

I run docker-compose run web bash, found redis and posgres both cannot be connected.

My docker-compose.yml file

web:
 build: .
  ports:
    - "8000:8000"
environment:
  - 'DATABASE_HOST=db'
  - 'DATABASE_NAME=mydb'
  - 'DATABASE_USER=root'
  - 'DATABASE_PASSWORD=root'
links:
  - db
db:
  image: postgres:9.1

when running sudo docker-compose up i got the following error.

web_1 |   File "/usr/local/lib/python2.7/site packages/django/db/backends/postgresql/base.py", line 175, in  get_new_connection

web_1 |     connection = Database.connect(**conn_params)
web_1 |   File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
web_1 |     conn = _connect(dsn, connection_factory=connection_factory, async=async)
web_1 | django.db.utils.OperationalError: could not connect to server: Connection refused
web_1 |     Is the server running on host "localhost" (::1) and accepting
web_1 |     TCP/IP connections on port 5432?
web_1 | could not connect to server: Connection refused
web_1 |     Is the server running on host "localhost" (127.0.0.1) and accepting
web_1 |     TCP/IP connections on port 5432?

Do you have anything in your Django settings to use those environment variables to define the database? — Daniel Roseman
– Daniel Roseman, Commented Jul 18, 2016 at 7:20
my django settings are: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'aiotadb', 'USER': 'root', 'PASSWORD': 'root', 'HOST': 'db', 'PORT': '5432', } } — Ashish Kumar Verma
– Ashish Kumar Verma, Commented Jul 18, 2016 at 7:36
also tried by changing 'HOST':'localhost' in settings file and changing 'DATABASE_HOST=localhost' in docker-compose.yml .still facing same issue. — Ashish Kumar Verma
– Ashish Kumar Verma, Commented Jul 18, 2016 at 7:50
I'm not sure why you're bothering to set those values in docker-compose.yml, since you aren't using them anywhere; you've hard-coded the settings. That error message is clearly showing that it is trying to access localhost, not db, though, so you should check that you really do have 'HOST': 'db'. — Daniel Roseman
– Daniel Roseman, Commented Jul 18, 2016 at 8:07

nirgn · Accepted Answer · 2016-08-09 15:58:18Z

2

I also built a clustering with docker-compose, it probably will help you and answer your problem (here is the repo). You can see the docker-compose.yml file, and the django settings file (I marked the lines you need).

You can also clone this repo and get django, angular2, postgresql, and nginx containers, all link together already.

edited Aug 9, 2016 at 15:58

answered Jul 18, 2016 at 8:47

nirgn

2,0834 gold badges24 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ashish Kumar Verma Over a year ago

Thanks @Nir I have tried these also,but still the error is same that Is the server running on host "localhost" (::1) and accepting.I have tried docker using sqlite3 and it worked as a charm.

nirgn Over a year ago

@AshishK. notice my docker-compose.yml file, my server (django) depends_on database. It means that server container will always wait for database container and spin up after it, and not before. Also, upload your settings.py file, notice the 'HOST': 'database' and'PORT': 5432 in mine (I think that is your problem. your host should be the name of the database container).

Ashish Kumar Verma Over a year ago

Thanks.Found the issue.Running successfully now.

Ashish Kumar Verma Over a year ago

port 5432 is not able to listen anything :)

levi · Accepted Answer · 2016-08-09 23:53:52Z

0

You are linking your web container with the postgres container but you are not defining database name, password and user.

  web:
   build: .
   ports:
    - "8000:8000"
   links:
    - db
  db:
    restart: always
    image: postgres:9.1
    ports:
      - "5432:5432"
    volumes:
      - pgvolume:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=root
      - POSTGRES_DB= aiotadb
      - POSTGRES_USER=root
   data:
    restart: always
    image: postgres:9.1
    volumes:
      - /var/lib/postgresql
    command: tail -f /dev/null

Also, if you already define your database options in your settings file, you don't need to declare it as env variables in web container.

answered Aug 9, 2016 at 23:53

levi

22.8k7 gold badges79 silver badges76 bronze badges

Comments

Roman Alekseiev · Accepted Answer · 2020-01-28 09:03:24Z

0

version: '3'
services:
  basicproject:
    build: .
    container_name: basicproject-container
    depends_on:
      - postgres
    ports:
      - "8000:8000"

  postgres:
    image: postgres:9.4
    ports:
    - "5432"
    environment:
      - POSTGRES_USER=test
      - POSTGRES_PASSWORD=testing
      - POSTGRES_DB=test_db

edited Jan 28, 2020 at 9:03

Roman Alekseiev

1,92120 silver badges25 bronze badges

answered Jan 28, 2020 at 7:00

Hemanth

11 bronze badge

Comments

Ibrahim Saifee · Accepted Answer · 2020-10-21 06:35:31Z

0

Add dependency in your 'web' service like below:

depends_on:
  - db

answered Oct 21, 2020 at 6:35

Ibrahim Saifee

313 bronze badges

Collectives™ on Stack Overflow

docker-compose does not start postgres

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related