PostgreSQL Replication

Replication is an advanced subject but this tutorial makes it so simple to assimilate thanks to a carefully structured approach based on examples and screenshots. As a PostrgreSQL administrator it will expand your horizons.

Overview

• Explains the new replication features introduced in PostgreSQL 9
• Contains easy to understand explanations and lots of screenshots that simplify an advanced topic like replication
• Teaches PostgreSQL administrators how to maintain consistency between redundant resources and to improve reliability, fault-tolerance, and accessibility

In Detail

PostgreSQL offers a comprehensive set of replication related features, which can be used to make your database servers more robust and way more scalable. Unleashing the power of PostgreSQL provides the user with countless opportunities and a competitive advantage over other database systems. To make things more powerful, PostgreSQL can be used in conjunction with a handful of sophisticated tools serving various different needs such as queuing, logical replication, or simplified transaction log handling.

"PostgreSQL Replication" is a practical, hands-on guide to PostgreSQL replication. It will provide you with the theoretical background as well as simple examples showing you how to make replication work on your system. A broad toolchain will be presented along with mature PostgreSQL-core technology.

"PostgreSQL Replication" starts with an introduction to replication concepts as well as the physical limitations of different replication solutions. You will be guided through various techniques such as Point-In-Time-Recovery, transaction-log-based replication and you will be introduced to a set of replication-related tools. In the final chapter you will learn to scale PostgreSQL to many different servers using PL/Proxy.

You will learn how to reset PostgreSQL to a certain point in time and figure out how to replicate data in many ways. You will deal with both synchronous as well as asynchronous replication. In addition to that, the book covers important topics, such as Slony, and upgrades with virtually no downtime. We will also cover important performance-related topics to make sure your database setups will provide you with high speed AND high availability.

"PostgreSQL Replication" contains all the information you need to design and operate replicated setups. You will learn everything you need to know for your daily work and a lot more.

What you will learn from this book

• Recover a PostgreSQL database to a certain point in time
• Set up asynchronous and synchronous streaming replication
• Handle transaction log files efficiently
• Learn about Linux High Availability
• Get to grips with Slony replication
• Get PL/Proxy to scale infinitely
• Understand pgpool and pgbouncer to improve speed and reliability
• Perform fast on-the-fly backups
• Increase reliability and throughput
• Improve data security and geographically distribute data

Approach

This book has a chapter dedicated to each aspect of replication. The new features of PostgreSQL 9 are introduced and there are lots of practical examples and screenshots.

複製是一個高級主題，但這本教程通過基於示例和屏幕截圖的精心結構化方法，使其變得非常容易理解。作為一個PostrgreSQL管理員，它將擴展您的視野。

概述
- 解釋了PostgreSQL 9中引入的新複製功能
- 包含易於理解的解釋和大量屏幕截圖，簡化了複製這樣一個高級主題
- 教導PostgreSQL管理員如何在冗余資源之間保持一致性，並提高可靠性、容錯能力和可訪問性

詳細內容
PostgreSQL提供了一套全面的複製相關功能，可以用來使您的數據庫服務器更加強大和可擴展。發揮PostgreSQL的威力為用戶提供了無數機會，並在其他數據庫系統上具有競爭優勢。為了使事情更加強大，PostgreSQL可以與一些複雜的工具結合使用，以滿足不同的需求，如隊列、邏輯複製或簡化的事務日誌處理。

《PostgreSQL複製》是一本實用的、實踐性的指南，介紹了PostgreSQL複製。它將為您提供理論背景，並通過簡單的示例向您展示如何在您的系統上實現複製。還將介紹一套成熟的PostgreSQL核心技術。

《PostgreSQL複製》從複製概念的介紹以及不同複製解決方案的物理限制開始。您將通過各種技術，如時間點恢復、基於事務日誌的複製，並介紹一套與複製相關的工具。在最後一章中，您將學習如何使用PL/Proxy將PostgreSQL擴展到許多不同的服務器上。

您將學習如何將PostgreSQL重置到特定的時間點，並找出如何以多種方式複製數據。您將處理同步和非同步複製。除此之外，本書還涵蓋了重要的主題，如Slony和幾乎無停機升級。我們還將涵蓋重要的性能相關主題，以確保您的數據庫設置能夠提供高速和高可用性。

《PostgreSQL複製》包含了設計和操作複製設置所需的所有信息。您將學到您日常工作所需的一切，以及更多。

從本書中您將學到：
- 將PostgreSQL數據庫恢復到特定的時間點
- 設置異步和同步流式複製
- 高效處理事務日誌文件
- 了解Linux高可用性
- 掌握Slony複製
- 使用PL/Proxy實現無限擴展
- 理解pgpool和pgbouncer以提高速度和可靠性
- 執行快速即時備份
- 提高可靠性和吞吐量
- 提高數據安全性並實現地理分佈數據

這本書的結構是每個複製方面都有一個專門的章節。介紹了PostgreSQL 9的新功能，並提供了大量的實用示例和屏幕截圖。