Install PostgreSQL 18 with PostGIS on Ubuntu 24.04
PostGIS adds spatial database features to PostgreSQL. With PostGIS, PostgreSQL can store geographic data such as coordinates, points, routes, and […]
Data Platforms & Analytics
PostgreSQL
Identity, Security & PKI
Enroll a Self-Hosted PostgreSQL into Teleport CE
This post shows how to enroll a self-hosted PostgreSQL (Ubuntu 24.04, PostgreSQL 16) into an existing Teleport Community Edition cluster
DevOps & Software Delivery
Deploy Backstage with Argo CD (GitOps) on Bare-Metal Kubernetes (Traefik + Wildcard HTTPS + In-Cluster PostgreSQL + Harbor)
This post shows how I manage my Kubernetes Backstage deployment using Argo CD, so Backstage is continuously reconciled from Git
DevOps & Software Delivery
Deploy Backstage to Kubernetes (Traefik Ingress, In-Cluster PostgreSQL, Harbor)
This post shows how I deploy my Backstage app (homelab-backstage) into Kubernetes while keeping my existing Backstage instance unchanged. This
DevOps & Software Delivery
Migrate Backstage Docker Deployment from SQLite to PostgreSQL
This guide shows how to run a production-style Backstage container that uses PostgreSQL (instead of SQLite), with secrets provided through
Data Platforms & Analytics
How to Install PostgreSQL on Ubuntu 24.04 (Ubuntu Repo vs PostgreSQL Repo)
Ubuntu 24.04 ships PostgreSQL in its own repositories (PostgreSQL 16 at the time of writing). The PostgreSQL Global Development Group
DevOps & Software Delivery
How to Install Redmine 6.0.6 on Ubuntu 24.04 with PostgreSQL, RVM Ruby, and HAProxy SSL
Redmine is a powerful, flexible, and open-source project management and issue tracking tool. Whether you’re managing software development, operations tasks,
Identity, Security & PKI
How to Sync Employee Data from an HR System to OpenLDAP
In most organizations, your HR system is the source of truth for employee identity data. Meanwhile, OpenLDAP is often used
Data Platforms & Analytics
Sync ThingsBoard Entity Data from PostgreSQL to Delta Lake Using Spark SQL
This post shows how to keep a Delta Lake table synchronized with a PostgreSQL table using only Spark SQL and
DevOps & Software Delivery
Artifactory OSS Setup on Bare Metal Ubuntu 24.04 with PostgreSQL 16
Overview Component Description OS Ubuntu Server 24.04 Artifactory OSS Installed via official APT repo Database PostgreSQL 16 (from PGDG repo)