PostgreSQL
Upgrading PostgreSQL: From 12 to 18 on RHEL8
PostgreSQL 12 reached EOL in November 2024. Here's how I upgraded to PostgreSQL 18 using the dump-and-restore method on RHEL 8.
PostgreSQL
Best practices for deploying, optimizing, and maintaining PostgreSQL relational databases.
Lessons Learned
What I Learned Installing Umami: Database Decisions and Docker
Seven lessons from installing Umami analytics: database compatibility, EOL software risks, Docker isolation, and why documentation is as valuable as code.
Umami
Adding Analytics to My Blog: The Umami Journey
Privacy-friendly analytics without Google: how I deployed Umami with PostgreSQL in Docker after learning hard lessons about database compatibility.