PGConfRu2019 Joshua Drake - «The Power of Logical Replication»

PGConfRu2019 Joshua Drake - «The Power of Logical Replication»
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.
One of the most soft after features of Postgres v10 is logical replication. In this presentation we will cover what Logical Replication is, how it compares to Binary (Streaming Replication), how Logical Replication works, configuring Logical Replication, Logical Replication limitations, gotchas, security and management. We will also discuss potential deployed architectures with Logical and Binary Replication and some neat features of the underlying technology.
At the end of this presentation an attendee with a reasonable understanding of how to manage Postgres will be able to configure Logical replication for use.
Talk page: pgconf.ru/en/2019/118144
#PGConfRu #PostgreSQL #Postgres #DBMS