In this blog post, I’ll show how to update PostgreSQL 14 on FreeBSD 13. Instead of running a database on my development machine, I run it on a FreeBSD virtual machine on my Intel NUC VMware ESXi homelab, and connect to it from anywhere thanks to Tailscale. First, I started by making a backup of my data and locating where my current PostgreSQL configuration lives: 1 2 $ pg_dumpall -U pgsql | gzip > backup.