Logical Replication...LIVE!
summary
Live demo of Postgres 10 logical replication shows how to set up publication/subscription pairs, enable WAL level = logical, and inspect replication slots while creating a publisher, subscribing a secondary, and watching full-table initial syncs and row-level changes apply. Key limits: not bi‑directional or multi‑master, schema is not copied (schemas must be created on replicas), truncate and sequences don’t replicate, replica identity / primary keys are required for updates, triggers run on replicas, and failover/tooling for logical setups is still immature.
AI-written summary · about
chapters (26)
- 0:00Intro
- 2:59Who am I
- 3:35Ground Rules
- 4:43What is Logical Replication
- 5:51What is Normal Replication
- 6:43Why use Logical Replication
- 9:39What is Robbinsville Replication
- 10:18Backwards Compatibility
- 12:01Streaming Replication
- 12:47Longrunning Transactions
- 14:01PGDump
- 14:56Replica Identity
- 15:46Failback
- 17:17Command Line
- 18:07Logs
- 18:47pgsql
- 21:25Starting the database
- 24:17Creating a publication
- 26:03Publishing a publication
- 26:52Creating a second database
- 30:00Testing the subscription
- 31:55Deleting data
- 33:22PG Replication
- 36:35Truncate
- 43:52Update ActorSet
- 51:32Update CountrySet
related talks
29mLogical replication theory and concepts
53mThe journey towards active replication in PostgreSQL
56mLogical Replication of DDLs
44mThe journey towards active-active replication in PostgreSQL
51mSpeeding up logical replication setup
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL
54mUnderstanding Logical Decoding and Replication
50mPGLogical the logical replication for Postgresql