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.
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…
Today’s roundup: SpaceX reportedly eyes Boost Mobile, Tesla Robotaxi launches in Fort Worth and Cybercab tours Europe, RHACM 2.17 adds an MCP server, SUSE cuts 10% of staff, and AlmaLinux moves its Vagrant boxes.
RHACM 2.17 exposes its multicluster search to AI assistants through a Technology Preview MCP server, alongside Lightspeed context and new GitOps and observability previews.
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.
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.
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.
Today’s roundup: SpaceX, Tesla, Red Hat news from the past day, with links to full write-ups.
Red Hat named JAL Digital, SoftBank, Sumitomo Mitsui Card Company and TOYOTA INDUSTRIES IT SOLUTIONS as Japan winners of its 2026 APAC Innovation Awards.
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.
