Can't create a postgres database with docker compose

Question

I can't create a postgres sql database using docker-compose.yml and an init file: I'm using docker-compose to create my local database without success

What I have inside my docker-compose file is the following:


version: '3'

services: 
    postgresql:
        image: postgres:alpine
        container_name: postgresql
        networks:
            - des-erp
        env_file:
            - ./postgresql/database.env
        ports:
            - 5444:5444
        volumes:
            - ./postgresql/init.sql:/docker-entrypoint-initdb.d/init.sql
            - postgres_data:/var/lib/postgresql/data

So I'm using a init file as an entrypoint, this is what the sql file looks like:

CREATE DATABASE my_datbase;

The path is correct, and I'm using the command: "docker-compose up -d" in the folder the docker-compose.yml is placed.

It does create the container but can't run the init.sql file, the error I can see in the container once created is the following:

psql:/docker-entrypoint-initdb.d/init.sql: error: could not read from input file: Is a directory.

My directory looks like the following, I'm in the "Backend" directory and this is what I can see:

ª   .gitlab-ci.yml
ª   docker-compose.yml
ª   README.md
+---postgresql\
        database.env
        init.sql

I do have the postgresql\init.sql file in the right place I believe
Im using Windows 11 btw
Any ideas?

Update: It does wrongly create a folder called "init.sql", that's why it can't execute it. I've added the ":ro" option to tell that this is a read-only file without success. — roderknight
– roderknight, Commented Apr 3, 2023 at 2:10
If Docker is creating init.sql as a directory, it means that there is no file in your local directory named ./postgresql/init.sql. Please update your question with the output of running tree . or find * -type f from the same directory that contains your docker-compose.yaml. — larsks
– larsks, Commented Apr 3, 2023 at 2:14

Ryabchenko Alexander · Accepted Answer · 2023-04-03 02:48:54Z

4

in volumes section you specify path to dirs not path to files

change

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

to

volumes:
   ./postgresql:/docker-entrypoint-initdb.d

or to

volumes:
   <path to dir with init.sql>:/docker-entrypoint-initdb.d

where <path to dir with init.sql> is propper local path

answered Apr 3, 2023 at 2:48

Ryabchenko Alexander

12.7k9 gold badges74 silver badges105 bronze badges

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

1 Comment

roderknight Over a year ago

I tried this one, It didn't work, it doesn't copy the file

Kozo · Accepted Answer · 2023-04-07 08:07:38Z

-1

Looks like the following things to be double-checked.

ports:
    - 5444:5444

The default port number is 5432. Please confirm if 5444 is the correct port number.

CREATE DATABASE my_datbase;

Please confirm if the correct name for the database is my_database.

Actually, the container I created on my local machine seems to be working well after confirming the above information.

answered Apr 7, 2023 at 8:07

Kozo

492 bronze badges

Collectives™ on Stack Overflow

Can't create a postgres database with docker compose

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related