Start postgres in Dockerfile

Question

When I use the postgres docker image, I run

docker run --name mydb -e POSTGRES_PASSWORD=password -d postgres

And I see a container running.

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                       NAMES
a36b98h8982a        postgres            "docker-entrypoint.s…"   36 minutes ago      Up 36 minutes       5432/tcp                    mydb

So I make my Dockerfile because I want to initialize my database

FROM postgres:latest

COPY pg-setup.sql /docker-entrypoint-initdb.d/

CMD ['postgres']

But when I use the Dockerfile the container just exits immediately. How do I get it to run like the postgres image?

There may be something wrong with the pg-setup.sql script. Could you post the logs? — b0gusb
– b0gusb, Commented Jan 15, 2019 at 7:20

Charles Xu · Accepted Answer · 2019-01-15 09:04:34Z

7

If your SQL file pg-setup.sql is no problem, you can just change your Dockerfile like this:

FROM postgres:latest
COPY pg-setup.sql /docker-entrypoint-initdb.d/

Take a look at another case. It will be helpful.

answered Jan 15, 2019 at 9:04

Charles Xu

31.8k2 gold badges26 silver badges42 bronze badges

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

2 Comments

RudolphEst Over a year ago

Yes, there is no need to override the CMD in your dockerfile. The command from the image will be used.

notAChance Over a year ago

this doesnt work at all for me: COPY failed: stat /var/lib/docker/tmp/docker-builder335488150/init.sql: no such file or directory

Collectives™ on Stack Overflow

Start postgres in Dockerfile

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related