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 2, 2026 · Zwiegnet Consulting
Tune PostgreSQL 18 on AlmaLinux 10: size shared_buffers, work_mem and WAL settings, enable pg_stat_statements, read EXPLAIN ANALYZE plans, add the right indexes and keep autovacuum ahead of the workload.
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
October 30, 2026 · Zwiegnet Consulting
Build a least-privilege PostgreSQL 18 permission layout on AlmaLinux 10: owner, read-only and read-write group roles, login roles, CONNECT and schema grants, ALTER DEFAULT PRIVILEGES, pg_hba.conf group rules, and safely dropping roles.
Read More
October 29, 2026 · Zwiegnet Consulting
Install PostgreSQL 18 on AlmaLinux 10 from AppStream or the PGDG repo, run initdb, configure pg_hba.conf with scram-sha-256, and allow remote access through firewalld with SELinux enforcing.
Read More
October 28, 2026 · Zwiegnet Consulting
Step-by-step guide to troubleshooting stuck and hung NFS mounts on AlmaLinux 10: hard vs soft mounts, D-state processes, stale file handles, forced and lazy unmounts, rpcinfo, nfsstat, tcpdump and server-side checks.
Read More
October 28, 2026 · Zwiegnet Consulting
firewall-cmd cheat sheet for RHEL, AlmaLinux, Rocky Linux, Oracle Linux and CentOS Stream: zones, services, ports, rich rules, NAT, policies, IP sets and troubleshooting.
Read More
October 28, 2026 · Zwiegnet Consulting
Build a central rsyslog log server on RHEL, AlmaLinux, Rocky Linux, Oracle Linux and CentOS Stream: TCP forwarding with disk queues, per-host files, logrotate, SELinux, firewalld and TLS.
Read More
October 27, 2026 · Zwiegnet Consulting
Build a three-node Kubernetes 1.37 cluster on AlmaLinux 10 with kubeadm, containerd and Calico, then deploy apps with Deployments, Services, ConfigMaps, Secrets and CronJobs.
Read More