Duration 3 Days – 21 hrs.
Overview
The EDB Postgres Distributed Essentials Training Course is designed to provide participants with the essential knowledge and practical skills required to deploy, manage, and maintain distributed PostgreSQL database environments using EDB Postgres technologies.
This course introduces participants to distributed database architecture, PostgreSQL replication, clustering, high availability, scalability, and disaster recovery concepts within enterprise PostgreSQL environments. Participants will learn how EDB Postgres supports mission-critical enterprise applications requiring resilient, scalable, and highly available database infrastructures.
Through hands-on exercises and real-world scenarios, participants will gain practical experience in configuring distributed PostgreSQL environments, managing replication and failover operations, monitoring database health and performance, securing distributed databases, and troubleshooting common operational issues.
Objectives
- Understand distributed PostgreSQL architecture and enterprise deployment concepts
- Install and configure EDB Postgres distributed environments
- Implement PostgreSQL replication and clustering solutions
- Configure high availability and failover environments
- Manage distributed PostgreSQL nodes and workloads
- Monitor database health, replication, and performance
- Perform backup and recovery operations
- Implement database security and access management
- Troubleshoot common distributed PostgreSQL issues
- Apply operational best practices for enterprise PostgreSQL environments
Target Audience
- Database Administrators (DBAs)
- PostgreSQL Administrators
- Linux System Administrators
- DevOps Engineers
- Infrastructure Engineers
- Cloud Engineers
- Platform Engineers
- Data Engineers
- IT Operations Teams
- Technical Support Professionals managing PostgreSQL environments
Prerequisites
- Basic understanding of relational database concepts
- Familiarity with PostgreSQL fundamentals
- Basic Linux administration knowledge
- Understanding of networking concepts
- Experience with SQL queries and database operations is recommended
Course Outline
Module 1: Introduction to EDB Postgres Distributed Architecture
- Overview of PostgreSQL architecture
- Introduction to distributed database concepts
- EDB Postgres platform overview
- Enterprise use cases for distributed PostgreSQL
- High availability and scalability concepts
- Distributed PostgreSQL deployment models
Module 2: Installing and Configuring EDB Postgres
- Installing EDB Postgres components
- Preparing Linux environments
- PostgreSQL initialization and configuration
- Managing PostgreSQL services
- Configuring network connectivity
- Managing users and roles
Module 3: PostgreSQL Replication Fundamentals
- Understanding replication concepts
- Streaming replication overview
- Primary and standby architecture
- Synchronous and asynchronous replication
- Configuring replication settings
- WAL (Write-Ahead Logging) basics
- Managing replication users and permissions
Module 4: High Availability and Failover
- High availability architecture concepts
- Configuring standby database servers
- Failover and switchover procedures
- Monitoring replication health
- Automatic failover concepts
- Disaster recovery planning basics
- Maintaining database resiliency
Module 5: Distributed Cluster Operations
- Managing distributed PostgreSQL nodes
- Cluster topology concepts
- Load balancing overview
- Connection pooling basics
- Managing database workloads
- Scaling PostgreSQL environments
- Cluster operational best practices
Module 6: Backup and Recovery
- Backup strategies for PostgreSQL
- Logical and physical backup methods
- WAL archiving concepts
- Point-in-time recovery (PITR)
- Restoring PostgreSQL databases
- Disaster recovery procedures
- Backup validation and testing
Module 7: Monitoring and Performance Optimization
- PostgreSQL monitoring tools overview
- Monitoring replication and cluster health
- Basic performance tuning techniques
- Resource utilization monitoring
- Query optimization fundamentals
- Database maintenance tasks
- Identifying and resolving performance bottlenecks
Module 8: Security and Access Management
- PostgreSQL authentication methods
- Managing database roles and privileges
- Securing database communications
- SSL/TLS overview
- Audit logging concepts
- Database security best practices
- Compliance and governance considerations
Module 9: Troubleshooting Distributed PostgreSQL
- Diagnosing replication issues
- Troubleshooting node synchronization problems
- Resolving connectivity issues
- Analyzing PostgreSQL logs
- Handling node failures
- Resolving performance-related issues
- PostgreSQL operational troubleshooting techniques
Module 10: Enterprise Best Practices
- Designing resilient PostgreSQL environments
- Capacity planning basics
- Patch and upgrade management
- Operational governance and standards
- Documentation and maintenance procedures
- Change management considerations
- Best practices for production deployments
Hands-On Labs and Practical Exercises
- Installing and configuring EDB Postgres environments
- Setting up PostgreSQL replication
- Configuring standby and failover environments
- Managing distributed PostgreSQL nodes
- Performing backup and recovery operations
- Monitoring PostgreSQL performance and replication health
- Implementing PostgreSQL security configurations
- Troubleshooting replication and cluster issues
- Simulating failover and recovery scenarios
- Managing enterprise PostgreSQL operational tasks
