November 11, 2026 · Zwiegnet Consulting
Back up MariaDB/MySQL on AlmaLinux 10 with mariadb-dump and mariadb-backup, automate it with a systemd timer, and restore fully, per database or to a point in time.
Read More
November 7, 2026 · Zwiegnet Consulting
PostgreSQL on AlmaLinux series, part 6. Previous: part 5, PostgreSQL Performance Tuning on AlmaLinux 10: postgresql.conf, EXPLAIN ANALYZE, Indexes and Autovacuum. Next: part 7, PostgreSQL SSL/TLS and PgBouncer Connection Pooling…
Read More
November 1, 2026 · Zwiegnet Consulting
Set up PostgreSQL 18 streaming replication on AlmaLinux 10 with a replication slot, verify it, then perform a switchover, an unplanned failover and rejoin the old primary with pg_rewind.
Read More
October 31, 2026 · Zwiegnet Consulting
Back up and restore PostgreSQL 18 on AlmaLinux 10 with pg_dump, pg_dumpall –globals-only and pg_basebackup, verify backups with pg_verifybackup, and schedule nightly dumps with a systemd timer.
Read More