How to initialize a PSQL database in docker-compose file?

docker docker-compose psql
albertoivo picture albertoivo · Nov 6, 2018 · Viewed 6.9k times · Source

I would like to know if it's possible to execute a PSQL command inside the docker-compose file.

I have the following docker-compose.yml:

version: '3' 
services:
  postgres:
    image: postgres:9.6
    container_name: postgres-container
    ports:
      - "5432:5432"
    network_mode: host
    environment:
      - LC_ALL=C.UTF-8
      - POSTGRES_DB=databasename
      - POSTGRES_USER=username
      - POSTGRES_PASSWORD=
      - POSTGRES_PORT=5432

And After this is running ok, I run the following command: docker exec -i postgres-container psql -U username -d databasename < data.sql

These 2 steps works fine. But I would ike to know if it's possible to make one single step.

Every time I want to run this command. It's important the database is always new. That's why I don't persist it in a volume and want to run this command.

Is it possible to run docker-compose up and also run the psql command?

Thanks in advance!

Answer

Siyu picture Siyu · Nov 6, 2018

Pure docker-compose solution with volume, 

  volumes:
    - ./data.sql:/docker-entrypoint-initdb.d/init.sql

According to the dockerfile, at start up, it will dump in every sql data in docker-entrypoint-initdb.d

Related questions

Using Docker-Compose, how to execute multiple commands

I want to do something like this where I can run multiple commands in order. db: image: postgres web: build: . command: python manage.py migrate command: python manage.py runserver 0.0.0.0:8000 volumes: - .:/code ports: - "8000:8000" links: - db

Read More
How to rebuild docker container in docker-compose.yml?

There are scope of services which defined in docker-compose.yml. These service have been started. I need to rebuild only one of these and start it without up other services. I run the following commands: docker-compose up -d # run all …

Read More
How to fix docker: Got permission denied issue

I installed Docker in my machine where I have Ubuntu OS. After than I installed docker, when I run sudo docker run hello-world All it's ok, but I want to hide the word sudo to make more short the command. …

Read More