November 8, 2026 · Zwiegnet Consulting
Enable SSL/TLS in PostgreSQL 18 on AlmaLinux 10 with a private CA, enforce hostssl and verify-full, add client certificates, then pool connections with PgBouncer using SCRAM auth_query and TLS.
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 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
August 5, 2026 · Zwiegnet Consulting
Install PostgreSQL on CentOS. PostgreSQL is used for a lot of business applications, and runs arguably much better on Linux than Windows (then again, what doesn’t?). This walkthrough is the…
Read More