Understanding Replication Concepts
The CAP theory and physical limitations
Different types of replication
Using sharding and data distribution
Understanding the PostgreSQL Transaction Log
Understanding consistency and data loss
Tuning checkpoints and the XLOG
The internal structure of the XLOG
Understanding Point-In-Time-Recovery
Understanding the purpose of PITR
Making use of traditional methods to create base backups
Keeping an eye on network bandwidth
Setting up Asynchronous Replication
Setting up streaming replication
Configuring a cascaded replication
Mixing streaming and file-based recovery
Making the streaming-only replication more robust
Efficient cleanup and the end of recovery
Setting up Synchronous Replication
Setting up synchronous replication
Understanding practical implications and performance
Redundancy and stopping replication
Checking for operating system processes
Understanding Linux High Availability
Understanding the purpose of high availability
History of high-availability software
High availability is all about redundancy
PostgreSQL and high availability
Understanding fundamental pgbouncer concepts
Configuring your first pgbouncer setup
Understanding the pgpool architecture
Setting up replication and load balancing
Running pgpool with streaming replication
Dealing with failovers and high availability
Replicating your first database
Adding tables to replication and managing problems
Using londiste to replicate data
Understanding the Postgres-XC architecture
Creating the tables and issuing the queries
Handling failovers and dropping nodes
Understanding the basic concepts