I'm the Product Manager for EDB Postgres Distributed (PGD). Here I document my work with distributed databases, security best practices, and Kubernetes orchestration — the practical side of running serious workloads on PostgreSQL.
A question I've fielded from Oracle DBAs since 2009: does Postgres need root, and does that mean no separation of duties? What the PGDG packages actually do, the standards behind them, and where Oracle is legitimately strong.
Sequence sync, update_deleted, subscriptions over a foreign server, per-subscription timeouts, EXCEPT and logical decoding without a restart: what each one is for, how to try it on a pair of nodes, and the gotchas I hit doing that.
What I learned putting a multi-node Postgres lab on apple/container instead of Docker Desktop: name resolution, address families, signal handling, and the numbers.
Why encrypting data at rest matters for Postgres, what TDE protects you from, and how it covers the soft targets most teams forget — like backups.
How User Profiles in EDB Postgres Advanced Server enforce password complexity, lock out brute-force attempts, and help you meet organizational password policy.
