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

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:

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

[alexandergustafsson]

This was a life saver thank you so much 🥰

[rjflip]

Why would my docker container immediately exit if I did the same docker run command?

[chobblegobbler]

How can I do the same from docker-compose?