Skip to Main Content

Running Postgres in Docker

Stephen Townshend

Developer Advocate (SRE)

So you want to spin up a Postgres database on your local machine, but you don't fancy having to install and manage everything manually? Running Postgres inside Docker is a great way to simplify the situation. It lets you:

In this article I will explain how to do this step by step.

Before you begin

You will need Docker Desktop installed on your machine and have it running.

In order to test that your Postgres instance is working you will also need an IDE to connect to it and run queries. The de facto standard for Postgres IDEs is pgAdmin which is available for Windows or Mac (and many other platforms), but in the past I preferred HeidiSQL (only available on Windows).

Instructions

Firstly, from a terminal or PowerShell session, pull the latest Postgres container image to your local image repository:

docker pull postgres:latest

Next, let's create a persistent volume in Docker to store our databases, tables, and data. This will allow us to retain our data even when our container is shut down:

docker volume create postgres-volume

I've called my persistent volume "postgres-volume".

Lastly we can start our Postgres container using:

docker run --name my-postgres --env POSTGRES_PASSWORD=admin --volume postgres-volume:/var/lib/postgresql/data --publish 5432:5432 --detach postgres

Here's a breakdown of what the command is doing:

Testing it worked

I'm going to use pgAdmin below, but you can use any database IDE you like that supports Postgres.

When you start pgAdmin for the first time it will prompt you to create a master password and then register a server. If this is not your first time, right click on Servers and select Register > Server...

In the General tab give your connection a name:

In the Connection tab enter "localhost" as the Host name/address and then under Password enter the password you set when you created your Postgres container ("admin" in the example I provided):

Click Save and it will automatically connect to your Postgres instance. From here you can create and browse databases and tables (I created one called "Deleteme" in the screenshot below) or run queries to confirm that everything is working as expected:

Summary

Running apps using Docker is a great way to keep your local machine clean. It's easier to manage a container than all of the files potentially spread across your computer when you install it manually.

Remember that containers are ephemeral, they are frequently created and destroyed. Whenever an app requires persistent storage, make sure you configure it to use a persistent volume (in Docker) or the equivalent in Kubernetes would be a persistent volume claim (PVC).

Share this article to LinkedInShare this article on XShare this article to Facebook
Stephen Townshend

Developer Advocate (SRE)

Visualize over 60 data sources, including:

View all 60+ plugins