PostgreSQL 9 Replication & Recovery
Targets
- Database Administration
- Systems Administration
- Business Continuity and Operations
- DevOps
Topics
- pg_dump and restore options
- PITR Backup and Recovery
- Replication Concepts
- High Availability options
- Streaming Replication
- Managing clusters using repmgr
- Hot Standby
- Synchronous Replication
- File based Log Shipping
- Slony & Londiste
- Connection Pooling
- Upgrading PostgreSQL
- Sharding and Scale Out
Requirements
- Basics of systems administration
- Basics of PostgreSQL database administration
- PostgreSQL basics
- Basics of applications design with PostgreSQL
Course acquired skills
- Advanced PostgreSQL database administration
- Advanced database architecture techniques
- Basics of database replication with PostgreSQL
- Basics of database scalability with PostgreSQL
- Basics of high availability and recovery with PostgreSQL
