Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Thursday, May 13 • 16:00 - 17:00

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

This talk presents an overview of the many forms of replication currently supported in Postgres.

Here's a breakdown of the topics that will be covered:
- We start with the replication configurations and which includes:
- multi node PRIMARY-STANDBY replication cluster
- Cascading Replication
- Other:
- Replicating to another READ-WRITE host
- active-active
- analytics
- Replicating to a READ-ONLY host using a time delay
- Working with detached READ-ONLY systems

- There are three (3) forms of replicating technologies that have been developed for database systems:
- statement replication
- trigger replication
- binary (the most commonly used solution)

- There are two types, or classifications, of replication which is used by Postgres:
- asynchronous replication
- synchronous replication

Of course this is by no means a complete list as there are so many methods and their variations which are possible in Postgres.

avatar for Robert Bernier

Robert Bernier

PostgreSQL Consultant, Percona
Robert's experience extends several decades. His first experience was playing hangman on a DECwriter shortly after man first landed on the moon. His foray into commercial applications was programming Fortran, via punchcards, on an IBM 360 which in those days had 4MB RAM. Over the... Read More →

Thursday May 13, 2021 16:00 - 17:00 EDT
Room #5