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
How HAIP (Redundant Interconnect Usage) and Linux bonding protect the Oracle RAC private interconnect on Oracle Linux 9: choosing one, setup, oifcfg and gv$cluster_interconnects checks, failover tests and switching between them.
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
Build a bonded public network for Oracle RAC on Oracle Linux 9 with nmcli: active-backup vs 802.3ad LACP, bond options, failover testing, oifcfg and troubleshooting.
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
Prepare Oracle Linux 9 nodes for Oracle Grid Infrastructure and RAC 19c: oracle-database-preinstall-19c, grid user and ASM groups, limits, HugePages, THP, chrony, RemoveIPC and firewall.
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
Plan a two-node Oracle RAC 19c cluster on Oracle Linux 9: server sizing, ASM disk groups and voting files, public and private networks, node VIPs, SCAN and DNS records.
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 30, 2026 · Zwiegnet Consulting
Part 1 of the Oracle Infrastructure Series: how RAC, Grid Infrastructure, ASM, Data Guard and GoldenGate fit together on Oracle Linux 9 with Oracle 19c, plus 23ai/26ai differences.
Read More