Course Outline
1. PostgreSQL Standard Replication for Government
- Physical replication through Write-Ahead Log (WAL) streaming
- Synchronous and asynchronous replication methods
- Configuring primary and standby servers for enhanced reliability
- Utilizing replication slots to manage data consistency
- Procedures for manual failover in critical scenarios
- Logical replication for flexible data distribution
2. Managing Replication with RepMgr for Government
- Overview of RepMgr components and repository structure
- Installation and configuration processes
- Registering nodes to ensure network visibility
- Creating standby servers for redundancy
- Procedures for switchover and failover operations
- Enabling automatic failover with the repmgrd daemon
3. High Availability with PgPool-II for Government
- PgPool-II architecture and its role in high availability
- Installation and configuration guidelines
- Starting and stopping PgPool-II services
- Basic administration tools and commands for daily operations
- Managing replication and load balancing to optimize performance
- Configuring automatic failover and failback mechanisms
- Utilizing the Watchdog architecture for enhanced reliability
- Implementing connection pooling to improve resource efficiency
Requirements
- Comprehensive knowledge of PostgreSQL architecture and configuration
- Practical experience with Linux command line operations and database administration tasks
Audience
Database Administrators, DevOps Engineers, and System Architects who are responsible for maintaining the reliability, redundancy, and uptime of databases, particularly in environments designed for government use.
Testimonials (5)
A factual and practical approach to the subject. A nice atmosphere, conducive to asking questions.
Marcin - Santander Bank Polska S.A.
Course - Implementing High Availability in PostgreSQL
It was docker and container plus postgres DB inheritance feature which is not available in Oracle Database.
Manish Kumar
Course - PostgreSQL Essentials
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
Course - PostgreSQL Performance Tuning
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course - PostgreSQL Advanced DBA
new knowledges that can be apply in our system
