This is part 2 of a series about Postgres logical replication use-cases, and about how the feature set has evolved over the past ten years and ten releases, one architecture at a time. Part 1 built a hub-and-workers system for write scalability and has the table of what each release added, which this post assumes. Part 3 covers a zero-downtime major upgrade.
Database
Dimitri Fontaine: Consolidating databases with Postgres logical replication
Planet PostgreSQL0 views
Source:https://postgr.es/p/9x3
PreviousChristophe Pettus: The Deep EndNextChristophe Pettus: All Your GUCs in a Row: notify_buffers
Related posts
Designing for Chaos: Implementing Circuit Breakers and Bulkheads in Go
0dev.to Go
Dashboard or spreadsheet: the honest test for when you need software
0dev.to Database
Database and PostgreSQL
0dev.to Database
Copy only the missing rows from SQL Server to PostgreSQL from the command line
0dev.to Database
Your PostgreSQL UPDATE ... FROM Never Finishes: The Repeated Target Table That Turns It Into a Cross Join
0dev.to Database
OfficePrism: Benchmarking Agents on Single-Domain Operations Across Enterprise Business Functions
0arXiv cs.SE