Skip to content
Hallway
0:00 / 0:00

#postgres#logicalreplication

PostgreSQL Logical Replication Guide

Code with Lucian

62K subscribers • 1 video on Hallway

YouTube
  • Recommended by 2 people: 2 in engineering communities.

Intermediate. Assumes working knowledge.

66K views4 years ago2 recommendations

Databases and dataDistributed systemsPostgresDatabase internalsReplication and consistency

A step-by-step guide to setting up, monitoring, and understanding the limitations of logical replication in PostgreSQL.

- Content of this video - What is Logical Replication in Postgres? - Step by step Logical Replication setup Setting up the servers for Logical Replication - Selective Copy of the Data - Create the Publication - Create the Subscription - Postgres Limitations of Logical Replication - Monitoring Logical Replication - Best use-cases 🐘 Want to go deeper into PostgreSQL scaling? Get 40% off the complete course using the link below. codewithlucian.com/postgresql-ha/postgresql-logical-replicat…

Why it's here

2 people recommend this

What people say. Recommended as a promising guide for replicating large databases across different datacenters.

Moments people linked to

u/RubberDuck1920in r/PostgreSQL • Recommends

Best way to snapshot/backup and then replicate tables in a 100GB db to another server/db Hi. Postgres noob here. My customer asks if we can replicate 100gb of data in a live system. Different datacenters (Azure). I am looking into logical replication as a good solution, as I watched this video and it looks promising: PostgreSQL Logical Replication Guide I want to test this, but is there a way to first do a backup/snapshot of the tables like they are, then restor this on the target db, and then start the logical replication from the time of the snapshot? thanks.
10View on Reddit

u/lucian-12in r/compsci • Recommends

link to this video PostgreSQL Logical Replication Guide
1View on Reddit

u/lucian-12in r/PostgreSQL • Recommends

link to this video PostgreSQL Logical Replication Guide
1View on Reddit