Local installation

Go here and download postgresql

Double click on the downloaded file to install postgresql

Postgresql with docker

Pull postgresql docker image

# pull latest image
docker pull postgres

# pull a specific version
docker pull postgres:12

Run postgres container

# run latest container
docker run --name postgres -e POSTGRES_PASSWORD=test -d postgres

# run container even if it dies.
docker run --name postgres --restart unless-stopped -p 5432:5432 -e POSTGRES_PASSWORD=test -v /Users/folaukaveinga/Software/postgres/data:/var/lib/postgresql/data -d postgres

Now that you have postgresql installed, it’s time to connect it to an IDE and play around with it. The IDE that most people are using is pgadmin. It is a very nice interface to work with.