PGConfRu2019 Joshua Drake - «Practical Postgres Replication» - part 1

PGConfRu2019 Joshua Drake - «Practical Postgres Replication» - part 1

Tutorial

Joshua D. Drake is a PostgreSQL Consultant and has been consulting on PostgreSQL since Postgres95. He is the founder and lead consultant of Command Prompt, Inc., the oldest of the Postgres companies. Throughout his PostgreSQL career he has performed a variety of functions within the community including releasing an O'Reilly book on PostgreSQL, being part of the sysadmins and advocacy teams. He is a former Director for SPI (the non-profit for PostgreSQL.org), a Founder of United States PostgreSQL, Co-Chair for PostgresConf and President of the International Consultants Committee for the Chinese Postgres Promotion Union.

In this tutorial we will discuss Binary and Logical replication in a practitioner format. The topics that will be included are native Postgres replication technologies, configuring and managing them. We will also discuss performance and draw backs of various architectures (sync vs async etc...). At the end of this presentation the attendees will be able to configure a basic replication deployment with HOT Standby and well as have an understanding of other technologies such as Point in Time Recovery and cascading replication.

#PGConfRu #PostgreSQL #Postgres #DBMS