Setup Postgres using Docker¶

In some cases you might want to have postgres setup on your machine. Let us understand how we can setup Postgres using Docker.

If you are using our labs, the database will be pre-created by us with all the right permissions.
If you are using Windows or Mac, ensure that you have installed Docker Desktop.
If you are using Ubuntu based desktop, make sure to setup Docker.
Here are the steps that can be used to setup Postgres database using Docker.
- Pull the postgres image using docker pull
- Create the container using docker create.
- Start the container using docker start.
- Alternatively we can use docker run which will pull, create and start the container.
- Use docker logs or docker logs -f to review the logs to ensure Postgres Server is up and running.

docker pull postgres

docker container create \
    --name itv_pg \
    -p 5433:5432 \
    -h itv_pg \
    -e POSTGRES_PASSWORD=itversity \
    postgres

docker start itv_pg

docker logs itv_pg

You can connect to Postgres Database setup using Docker with docker exec.

docker exec \
    -it itv_pg \
    psql -U postgres

You can also connecto to Postgres directly with out using docker exec.

psql -h localhost \
    -p 5433 \
    -d postgres \
    -U postgres \
    -W

Mastering SQL using Postgresql

Setup Postgres using Docker¶