32图层 2 PIGSTY
32图层 2 PIGSTY
Docs Extensions Extensions are the soul of PostgreSQL. Pigsty builds, packages, collects, and integrates 562 PG ecosystem extensions for out-of-the-box use. Blog Articles about Pigsty, cloud computing, database industry, AI/Agent, and notes on PostgreSQL development, administration, and internals Module: PGSQL Deploy and manage world's most advanced open-source relational database — PostgreSQL, customizable and production-ready! patroni Overview of Patroni high-availability documentation for PostgreSQL. pgbackrest Reliable PostgreSQL Backup & Restore — pgBackRest documentation and reference. pgbouncer PgBouncer - Lightweight connection pooler for PostgreSQL pig PostgreSQL Extension Ecosystem Package Manager
    • Featured
      • OpenAI's PG Scaling
      • Self-Host Supabase
      • PG Eats DB World
      • Database in K8S
    • Pigsty
      • Pigsty v4.3 Release
      • Pigsty v4.2 Release
      • Pigsty v4.1 Release
      • Pigsty v4.0 Release
      • Pigsty v3.7 Release
      • Pigsty v3.6 Release
      • Pigsty v3.5 Release
      • Pigsty v3.4 Release
      • Pigsty v3.3 Release
      • Pigsty v3.2 Release
      • Pigsty v3.1 Release
      • Pigsty v3.0 Release
      • Pigsty v2.7 Release
      • Pigsty v2.6 Release
      • Pigsty v2.5 Release
      • Pigsty v2.4 Release
      • Pigsty v2.3 Release
      • Pigsty v2.2 Release
      • Pigsty v2.1 Release
      • Pigsty v2.0 Release
      • Pigsty v1.5 Release
      • Pigsty v1.4 Release
      • Pigsty v1.3 Release
      • Pigsty v1.2 Release
      • Pigsty v1.1 Release
      • Pigsty v1.0 Release
      • Pigsty v0.9 Release
      • Pigsty v0.8 Release
      • Pigsty v0.7 Release
      • Pigsty v0.6 Release
      • Pigsty v0.5 Release
      • Pigsty v0.4 Release
      • Pigsty v0.3 Release
    • Cloud
      • Don't Run AI Assistant on Cloud
      • Did RedNote Exit the Cloud?
      • Alipay, Taobao, Xianyu Went Dark. Smells Like a Message Queue Meltdown.
      • Cloudflare’s Nov 18 Outage, Translated and Dissected
      • Alicloud “Borrowed” Supabase. This Is What Happens When Giants Strip-Mine Open-Source.
      • AWS’s Official DynamoDB Outage Postmortem
      • How One AWS DNS Failure Cascaded Across Half the Internet
      • Column: Cloud-Exit
      • KubeSphere: Trust Crisis Behind Open-Source Supply Cut
      • Alicloud’s rds_duckdb: Tribute or Rip-Off?
      • Escaping Cloud Computing Scam Mills: The Big Fool Paying for Pain
      • OpenAI Global Outage Postmortem: K8S Circular Dependencies
      • WordPress Community Civil War: On Community Boundary Demarcation
      • Cloud Database: Michelin Prices for Cafeteria Pre-made Meals
      • Alibaba-Cloud: High Availability Disaster Recovery Myth Shattered
      • Amateur Hour Opera: Alibaba-Cloud PostgreSQL Disaster Chronicle
      • What Can We Learn from NetEase Cloud Music's Outage?
      • Blue Screen Friday: Amateur Hour on Both Sides
      • Ahrefs Saved $400M by NOT Going to Cloud
      • Google Cloud Database Deletion - UniSuper
      • Exploding Cloud Bills with Just S3 Bucket Names
      • Cloudflare Roundtable Interview and Q&A Record
      • What Can We Learn from Tencent Cloud's Major Outage?
      • Cloudflare - The Cyber Buddha That Destroys Public Cloud
      • Can Luo Yonghao Save Toothpaste Cloud?
      • Analyzing Alibaba-Cloud Server Computing Cost
      • Will DBAs Be Eliminated by Cloud?
      • Cloud-Exit High Availability Secret: Rejecting Complexity Masturbation
      • S3: Elite to Mediocre
      • Cloud Exit FAQ: DHH Saves Millions
      • From Cost-Reduction Jokes to Real Cost Reduction and Efficiency
      • Reclaim Hardware Bonus
      • Unofficial Post-mortem of Alibaba-Cloud's Epic Failure
      • Harvesting Alibaba-Cloud Wool, Building Your Digital Homestead
      • Cloud Computing Mudslide: Deconstructing Public Cloud with Data
      • Cloud Exit Odyssey: Time to Leave Cloud?
      • DHH: Cloud-Exit Saves Over Ten Million, More Than Expected!
      • FinOps: Endgame Cloud-Exit
      • Why Isn't Cloud Computing More Profitable Than Sand Mining?
      • SLA: Placebo or Insurance?
      • EBS: Pig Slaughter Scam
      • Garbage QCloud CDN: From Getting Started to Giving Up?
      • Refuting "Why You Still Shouldn't Hire a DBA"
      • Paradigm Shift: From Cloud to Local-First
      • Are Cloud Databases an IQ Tax?
      • Cloud RDS: From Database Drop to Exit
      • Is DBA Still a Good Job?
    • PostgreSQL
      • PG Turns 30
      • Extensions for Everyone
      • 504 Extensions: Expand the PostgreSQL Landscape
      • From AGPL to Apache: Why I Changed Pigsty's License
      • Git for Data: Instant PostgreSQL Database Cloning
      • Why PostgreSQL Will Dominate the AI Era
      • Forging a China-Rooted, Global PostgreSQL Distro
      • PG Extension Cloud
      • The PostgreSQL 'Supply Cut' and Trust Issues in Software Supply Chain
      • PostgreSQL Dominates Database World, but Who Will Devour PG?
      • SO2025 Survey: PostgreSQL Has Dominated the Database World
      • PGDG Cuts Off Mirror Sync Channel
      • PGEXT.DAY: See You at Extension Day
      • OrioleDB: Cloud-Native Bloat-Free PG
      • OpenHalo: MySQL-Compatible PG-Kernel
      • PGFS: Using Database as a Filesystem
      • PostgreSQL Ecosystem Frontier Developments
      • Pig - The Postgres Extension Wizard
      • Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails
      • PG12 EOL, PG17 Rises
      • The ideal way to deliver PostgreSQL Extensions
      • PostgreSQL Convention 2024
      • PG17 Released: No More Pretending!
      • Can PG Replace MSSQL?
      • DuckDB Integration = OLAP Victory
      • SO 2024: PostgreSQL Has Gone Berserk
      • Self-Hosting Dify with PG, PGVector, and Pigsty
      • PGCon.Dev 2024, The conf that shutdown PG for a week
      • PostgreSQL 17 Beta1 Released!
      • Why PostgreSQL is the Future Standard?
      • Will PostgreSQL Change Its License?
      • Postgres is eating the database world
      • Technical Minimalism: Just Use PostgreSQL for Everything
      • New PostgreSQL Ecosystem Player: ParadeDB
      • PostgreSQL's Impressive Scalability
      • PostgreSQL Outlook for 2024
      • PostgreSQL Wins 2024 Database of the Year Award! (Fifth Time)
      • PG Query Optimization: The Macro Way
      • FerretDB: PostgreSQL Disguised as MongoDB
      • How to Use pg_filedump for Data Recovery?
      • Vector is the New JSON
      • PG, The most successful database
      • AI LLMs and PGVector
      • How Powerful is PostgreSQL Really?
      • Why PostgreSQL is Most Successful?
      • Ready-to-Use PostgreSQL Distribution: Pigsty
      • Why Does PostgreSQL Have a Bright Future?
      • Implementing Advanced Fuzzy Search
      • Localization and Collation Rules in PostgreSQL
      • PG Replica Identity Explained
      • PostgreSQL Logical Replication Deep Dive
      • A Methodology for Diagnosing PostgreSQL Slow Queries
      • Incident-Report: Patroni Failure Due to Time Travel
      • Online Primary Key Column Type Change
      • Golden Monitoring Metrics: Errors, Latency, Throughput, Saturation
      • Database Management Entities and Naming Conventions
      • PostgreSQL's KPI
      • Online PostgreSQL Column Type Migration
      • Frontend-Backend Communication Wire Protocol
      • Transaction Isolation Level Considerations
      • Incident: Extension Causes Connection Denial
      • CDC Change Data Capture Mechanisms
      • Locks in PostgreSQL
      • O(n2) Complexity of GIN Search
      • PostgreSQL Common Replication Topology Plans
      • Warm Standby: Using pg_receivewal
      • Incident-Report: Connection-Pool Contamination
      • Incident-Report: Data Page Corruption
      • Relation Bloat Monitoring and Management
      • Getting Started with PipelineDB
      • TimescaleDB Quick Start
      • Incident-Report: Integer Overflow from Rapid Sequence Number Consumption
      • Incident-Report: PostgreSQL Transaction ID Wraparound
      • GeoIP Geographic Reverse Lookup Optimization
      • PostgreSQL Trigger Usage Considerations
      • PostgreSQL Development Convention 2018 Edition
      • What Are PostgreSQL's Advantages?
      • GIS Point-in-Polygon Query
      • KNN Ultimate Optimization: GIS Selection
      • Monitoring Table Size in PostgreSQL
      • PgAdmin Installation and Configuration
      • Incident: Uneven Load Avalanche
      • Bash and psql Tips
      • Distinct On: Remove Duplicate Data
      • Function Volatility Classification Levels
      • Implementing Mutual Exclusion Constraints with Exclude
      • PostgreSQL Routine Maintenance
      • Backup and Recovery Methods Overview
      • PgBackRest2 Documentation
      • Pgbouncer Quick Start
      • PostgreSQL Server Log Regular Configuration
      • Testing Disk Performance with FIO
      • Using sysbench to Test PostgreSQL Performance
      • Zero-Downtime Data Migration Basic Principles
      • Finding Unused Indexes
      • Batch Configure SSH Passwordless Login
      • Wireshark Packet Capture Protocol Analysis
      • FileFDW Use Case: Reading OS Info
      • Common Linux Statistics CLI Tools
      • Installing PostGIS from Source
      • Go Database Tutorial: database/sql
      • Implementing Cache Synchronization with Go and PostgreSQL
      • Auditing Data Changes with Triggers
      • Building an ItemCF Recommender in Pure SQL
      • UUID Properties, Principles and Applications
      • MongoFDW Installation and Deployment
    • AI
      • Cyber Dharma: A New Engineering Answer to Ancient Questions
      • Burning Hundreds of Millions of Tokens a Day. Then What?
      • Why PostgreSQL Won in the AI Era
      • AGI Is Here. Do You Have a Ticket?
      • Can You Distill an Expert?
      • Local AI's Inflection Point: 2027
      • Yes, I Use AI to Write
      • LLMs Have Emotions: Claude's Internals Reveal Steerable Emotion Vectors
    • Database
      • Two Months into Maintaining a MinIO Fork
      • Palantir's 'Ontology' Hustle
      • MinIO Is Dead, Long Live MinIO
      • When Coding Becomes Cheap, What Still Matters?
      • The Agent Moat: Runtime
      • AI Ripped the Skin Off Software
      • New Programmers in the AI Era: Where Do You Go?
      • The Great Software Meltdown: When Translation Layers Get Squashed
      • Agent OS: We're Building DOS Again
      • Claude Code Observability
      • Claude Code Quick Start Guide
      • Data 2025: Year in Review with Mike Stonebraker
      • What Database Does AI Agent Need?
      • MySQL and Baijiu: The Internet’s Obedience Test
      • Victoria: Observability Stack Arrives
      • MinIO Is Dead. Who Picks Up the Pieces?
      • MinIO is Dead
      • When Answers Become Abundant, Questions Become the New Currency
      • On Trusting Open-Source Supply Chains
      • Don't Run Docker Postgres for Production!
      • DDIA 2nd Edition, Chinese Translation
      • Column: Database Guru
      • Dongchedi Just Exposed “Smart Driving.” Where’s Our Dongku-Di?
      • Google AI Toolbox: Production-Ready Database MCP is Here?
      • Where Will Databases and DBAs Go in the AI Era?
      • Stop Arguing, The AI Era Database Has Been Settled
      • Open Data Standards: Postgres, OTel, and Iceberg
      • The Lost Decade of Small Data
      • Scaling Postgres to the Next Level at OpenAI
      • How Many Shops Has etcd Torched?
      • In the AI Era, Software Starts at the Database
      • MySQL vs. PostgreSQL @ 2025
      • Database Planet Collision: When PG Falls for DuckDB
      • Comparing Oracle and PostgreSQL Transaction Systems
      • Database as Business Architecture
      • 7 Databases in 7 Weeks (2025)
      • Solving Poker 24 with a Single SQL Query
      • Self-Hosting Supabase
      • Modern Hardware for Future Databases
      • Can MySQL Still Catch Up with PostgreSQL?
      • Open-Source Tyrant Linus Purges His Court
      • Optimize Bio Cores First, CPU Cores Second
      • Mongo Has No Future
      • MongoDB: Now Powered by PostgreSQL
      • Switzerland Mandates Government Open-Source
      • MySQL is dead, Long live PostgreSQL!
      • CVE-2024-6387 SSH Vulnerability Fix
      • Can Oracle Still Save MySQL?
      • Oracle Finally Killed MySQL
      • MySQL Performance Declining: Where is Sakila Going?
      • Can Chinese Domestic Databases Really Compete?
      • The $20 Brother PolarDB: What Should Databases Actually Cost?
      • Redis Non-Open-Source is a Disgrace
      • How Can MySQL's Correctness Be This Garbage?
      • Database in K8S: Pros & Cons
      • Are Specialized Vector Databases Dead?
      • Are Databases Really Being Strangled?
      • Which EL-Series OS Distribution Is Best?
      • What Kind of Self-Reliance Do Infrastructure Software Need?
      • Back to Basics: Tech Reflection Chronicles
      • Database Demand Hierarchy Pyramid
      • Are Microservices a Bad Idea?
      • NewSQL: Distributive Nonsense
      • Time to Say Goodbye to GPL
      • PG in Docker: Good or Bad?
      • Understanding Time - Leap Years, Leap Seconds, Time and Time Zones
      • Understanding Character Encoding Principles
      • Concurrency Anomalies Explained
      • Blockchain and Distributed Databases
      • Consistency: An Overloaded Term
      • Why Study Database Principles
  1. Blog
  2. PostgreSQL
  3. PostgreSQL Common Replication Topology Plans

PostgreSQL Common Replication Topology Plans

Replication is one of the core issues in system architecture.
By vonng · Published March 29, 2019 · PostgreSQL

featured

Replication is one of the core issues in system architecture. Read more

  • ←Previous
  • Next→
Last Modified: 2026-04-17: adjust blog (769772b)
View Page Source Edit Current Page Create Child Page Create Docs Issue Create Project Issue Print Entire Section
PostgreSQL131 Database51 PG-Admin42 Pigsty37 Cloud-Exit36 AI22 PG-Ecosystem22 PG-Development20 Extension14 Open-Source13 Cloud-Outage11 MySQL10 Agent9 Alibaba-Cloud8 Cloud8 Incident-Report8 Performance8 RDS8 Architecture5 AWS5 DBA5 MinIO5 Cloudflare4 Domestic-Database4 S34 Tools4 Backup3 Claude3 DHH3 Docker3 DuckDB3 Ecosystem3 GIS3 Hardware3 industry3 Kubernetes3 Monitoring3 Oracle3 Supabase3 Triggers3 Data-Corruption2 EBS2 ECS2 Extensions2 License2 Metrics2 Migration2 MongoDB2 Observability2 OpenAI2 OS2 Philosophy2 SQL2 Tencent-Cloud2 Alignment1 Aliyun1 Anthropic1 Business1 CDC1 CDN1 ClaudeCode1 ClickHouse1 Codex1 Connection-Pool1 Convention1 Data1 databases1 DBOS1 DDIA1 Development1 Distributed1 Emotion1 Encoding1 etcd1 FinOps1 Full-Text-Search1 Functions1 GIN1 Go1 GPL1 Grafana1 Iceberg1 JuiceFS1 KNN1 Linux1 Local First1 Lock1 Logging1 MCP1 Microservices1 MSSQL1 NewSQL1 OLAP1 ontology1 OpenSource1 OpenTelemetry1 Operating-System1 OSS1 PG-Kernel1 PigstyApp1 Privacy1 Recommendation System1 Redis1 RedNote1 Religion1 Security1 Serverless1 SLA1 Software Engineering1 SQLite1 Supply Chain1 Tech Commentary1 Tool1 Vector1 Vector-Database1 Vector-DB1 Victoria1 VictoriaMetrics1 Vulnerability1 Writing1
© 2018-2026 Ruohang Feng (Vonng) @ PGSTY
中文
↑↓ to navigate ↵ to select esc to close