Category: PostgreSQL

Upgrading PostgreSQL on Linux with pg_upgrade

October 5, 2026

In this post, we’ll look at how to upgrade a PostgreSQL installation on Linux. In this example, we’ll look at an in-place upgrade on Debian from PostgreSQL version 15 to 18. The version 15 cluster will already be up and running and we’re going to use pg_upgrade to do it. The upgrade process is: The…
Keep reading
Setting up the Stack Overflow database in Postgres

August 10, 2026

I’ve worked with Microsoft SQL Server for many years as well as dipping my toes into the MySQL world as and when required, however, I have not done as much with PostgreSQL. It’s hard to ignore the momentum that Postgres has built in recent years; it is moving up the Stack Overflow Developer Survey and…
Keep reading
Four Flavours of Postgres Install – Part 4 (Windows)

August 3, 2026

This post is the next in a short series exploring the different ways we can install a PostgreSQL server. This time, we’ll look at a vanilla install on Windows – no Docker involved. The VM I’ll use the same spec VM as in the last post, which is sufficient for demonstration purposes: Firstly, let’s hop…
Keep reading
Four Flavours of Postgres Install – Part 3 (Docker Container, Windows Host)

July 27, 2026

In this series, we’ve been working through the different ways to install PostgreSQL. In Part 3, we move into the Windows world and will install PostgreSQL as a Docker container. Unlike Part 2, where the host was a Linux machine, this time, the host is a Windows server. The VM I’ll use the same spec…
Keep reading
Four Flavours of Postgres Install – Part 2 (Docker Container, Linux Host)

July 20, 2026

In the last post, the first in this series about installing PostgreSQL, we looked at how to install PostgreSQL on Linux. This post is an alternative install method where we’ll look at how to install PostgreSQL on a Docker container, where the container is run on a Linux host. As before, we’ll run through the…
Keep reading
Four Flavours of Postgres Install – Part 1 (Linux)

July 13, 2026

This is the first post in a short series documenting the various methods of installing PostgreSQL. In this post, we’ll look at how to install PostgreSQL natively on Linux and connect to the cluster we install from a remote client. The VM Firstly, let’s create a VM to install PostgreSQL on. I won’t detail the…
Keep reading
Installing PGAdmin on Linux Mint

June 29, 2026

This is a quick walkthrough of how I installed pgAdmin on Linux Mint. pgAdmin is one of the main management and query tools for PostgreSQL, which I like to use in conjunction with DBeaver. Installation The pgAdmin tool isn’t in the standard Linux Mint repositories, only phpPgAdmin, which is a web-based tool, similar to the…
Keep reading