How to run PostgreSQL inside a Docker container
I showcase how we can create a docker container running a PostgreSQL Database. We then add some SQL to the database, and go into the container to access the database to check everything works as intended.
Dockerfile:
FROM postgres
ENV POSTGRES_PASSWORD docker
ENV POSTGRES_DB user
COPY user.sql /docker-entrypoint-initdb.d/
Commands:
Build docker image:
docker build -t dbpost .
Run doker contianer from image:
docker run -d –name my-postgresdb-container -p 5432:5432 dbpost
Get into the docker container:
docker exec -it [container id] /bin/bash
Get into postgreSQL:
psql -U postgress
My channel publishes programming and software engineering videos, especially Java and Python. If that is what you are looking for, do not hesitate to join me on this journey!
Subscribe to my YouTube channel:
https://www.youtube.com/channel/UCyjEXAHK8xfRmlnkat2ympQ?sub_confirmation=1
0:00 Intro
0:35 Dockerfile
1:14 Docker build
2:06 Docker run
3:37 Inside the docker contianer
4:45 Inside PostgreSQL
7:18 Summary