Dok Talks #112 - Production Postgres Made Easy on Kubernetes // Jonathan Katz

https://go.dok.community/slack
https://dok.community/

ABSTRACT OF THE TALK

It's one thing to get a database up and running on Kubernetes; it's another to run it in production.

There are many "Day 2" features to think about when running any database in production, including high availability, backups + RTO/RPO, monitoring, security, and disaster recovery. Combining Kubernetes with the Operator pattern can help make this easier, and add advanced features like self-healing, simple scaling, secure credential management, and more.

PGO, the open source Postgres Operator from Crunchy Data, makes it easy to manage production Postgres clusters on Kubernetes the GitOps way. Using simple manifests, PGO deploys HA Postgres clusters with self-healing capabilities that apps can securely connect to.

In this talk we will review the important concepts to know for running databases in production, how PGO implements these features, and then spend most of the time demoing how all of the key "Day 2" features work with a PGO-managed Postgres databases connected with an application!

BIO

Jonathan S. Katz is the VP of Platform Engineering at Crunchy Data, with a focus on managing PGO, an open source Postgres Operator.

Jonathan is a member of the PostgreSQL Core Team and involved in various governance aspects of the PostgreSQL Global Development Group. He serves as a Secretary and Director of the nonprofit PostgreSQL Community Association of Canada and is a Director of the nonprofit United States PostgreSQL Association. He has given talks at conferences all over the world for over a decade on topics involving Postgres, from application developer uses to operations, particularly focusing on Kubernetes over the past several years.

Prior to Crunchy Data, Jonathan was CTO at VenueBook, and before that, VP of Technology at Paperless Post. At both companies Jonathan developed robust platforms using PostgreSQL, taking advantage of its many features, from complex data types to its ability to stream logical changes. Jonathan graduated from Tufts University with a B.S. in Computer Science and a B.A. in Mathematics.