What we built with Open Source
summary
Shows concrete systems and numbers: a Postgres stack that encrypts data files, WAL and backups with key‑manager integration and a replication proxy for on‑the‑fly encrypt/decrypt; automation running Postgres/PGE in Kubernetes to manage 11,000 systems with standardized patching, auditing and migration tooling; a migration workflow that tracks schema drift and automates large fleet moves instead of one‑off fixes; Patroni extensions for multi‑data‑center failover and efficient major upgrades for 200 terabyte databases.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 1:05Postgres fundamentals and ecosystem
- 3:53Balancing open source and specific needs
- 8:09Postgres encryption challenges
- 11:22Operational challenges at scale
- 14:08Automation and Kubernetes integration
- 17:22Private cloud and regulatory needs
- 19:14Bulk assessment for large migrations
- 21:03Change management and compliance
- 23:30Regulations and compliance tools
- 25:14Fraud detection in Postgres
- 27:01Multi-data center Kubernetes operator
- 28:51Efficient major release upgrades
- 30:19Closing the open source loop
- 31:24Postgres education and certification
- 32:50Q&A on regulated business challenges
related talks
13mBuilding reliable infrastructure with Postgres
46mBig databases, many servers, data center or cloud - it's all here!
51mWhen Postgres Can't, You Can!
08mUsing PostgreSQL in real life
29mBuilding Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL
11mDriving fully open source enterprise readiness for Postgres
51mScaling Postgres to the next level at OpenAI
10mUsing your Favorite Open Source Database at Enterprise Scale in Financial Services