Jan Karremans leads the sales organization at CYBERTEC boasting over 30 years of experience in the database market. As an Oracle ACE alumni as well as a certified PostgreSQL professional, Jan is a well-respected expert in relational database technologies. Combining technology, business, and commercial aspects enables a unique understanding of customer cases and guiding customers and partners to success with Postgres.
Join this talk to learn how to secure your database in Postgres using streaming replication,
from the very BASIC to the very ADVANCED. After all, even if your database is small, your
data might still be precious. And as your project grows and gets bigger, your Postgres
environment will need to be adapted to scale with it.
This talk will give you a beginner’s guide to streaming replication in Postgres, and more
specifically, you will learn about WAL (write-ahead logging), how to prepare for DR, and how
to use the `pg_receivewal` utility in a large setup with cascading replicas, continuous
backup, etc. You’ll also learn about the concepts of RTO and RPO and how to scale your
data protection architecture as your application grows.
Why attend this talk? Because the amazing power of streaming replication in PostgreSQL
is too under-appreciated.
Based on over two decades of practical experience, you will be guided through some of the
pitfalls and get introduced to the full range of Postgres Disaster Resilience techniques.