- PostgreSQL Replication
- Table of Contents
- PostgreSQL Replication
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Understanding Replication Concepts
- The CAP theory and physical limitations
- Different types of replication
- Using sharding and data distribution
- Summary
- 2. Understanding the PostgreSQL Transaction Log
- How PostgreSQL writes data
- The PostgreSQL disk layout
- Looking into the data directory
- PG_VERSION – PostgreSQL version number
- base – the actual data directory
- global – the global data
- pg_clog – the commit log
- pg_hba.conf – host-based network configuration
- pg_ident.conf – ident authentication
- pg_multixact – multi-transaction status data
- pg_notify – LISTEN/NOTIFY data
- pg_serial – information about committed serializable transactions
- pg_snapshot – exported snapshots
- pg_stat_tmp – temporary statistics data
- pg_subtrans – subtransaction data
- pg_tblspc – symbolic links to tablespaces
- pg_twophase – information about prepared statements
- pg_XLOG – the PostgreSQL transaction log (WAL)
- postgresql.conf – the central PostgreSQL configuration file
- Writing one row of data
- Read consistency
- The PostgreSQL disk layout
- The XLOG and replication
- Understanding consistency and data loss
- Tuning checkpoints and the XLOG
- The internal structure of the XLOG
- Summary
- How PostgreSQL writes data
- 3. Understanding Point-In-Time-Recovery
- 4. Setting up Asynchronous Replication
- 5. Setting up Synchronous Replication
- Setting up synchronous replication
- Understanding practical implications and performance
- Redundancy and stopping replication
- Summary
- 6. Monitoring Your Setup
- 7. Understanding Linux High Availability
- 8. Working with pgbouncer
- 9. Working with pgpool
- 10. Configuring Slony
- 11. Using Skytools
- 12. Working with Postgres-XC
- 13. Scaling with PL/Proxy
- Index
In this chapter, you have learned about Point-In-Time-Recovery, which is a safe and easy way to restore your PostgreSQL database to any desired point in time. PITR will help you to implement better backup policies and make your setups more robust.
In the next chapter we will extend this topic and turn to asynchronous replication. You will learn how to replicate an entire database instance using the PostgreSQL transaction log.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.