Diary of an IT Architect

Copypastable tutorials I wrote for my reference. You're welcome.

According to their homepage headline, PostgreSQL is world's most advanced open source relational database. More and more services here at Mimar rely on it, of which perhaps most popular would be GitLab, Synapse and Mattermost. While basic administrative tasks in PostgreSQL can be performed by means of interactive terminal, psql, most admins will find pgAdmin a better tool for the job. This article gives exact steps how to configure pgAdmin4 as web application hosted in Apache HTTP Server name-based VirtualHost on FreeBSD.

Continue reading...

Regarding FreeBSD and RAID, first thing that comes to mind is surely ZFS and RAIDZ. But in some cases, good old gmirror of UFS partitions can be useful as well, for example when we want to place OS on a pair of smaller SSDs for speed, while having another set of slower SATA HDDs for ZFS storage. This article shows exact steps how to install FreeBSD in UEFI mode onto (mostly) UFS partitions residing on gmirror RAID1.

Continue reading...