Course Code: postgresadmin2bspk
Duration: 21 hours
Course Outline:

·  Introduction

·  Performance Monitoring and Tuning

  • Monitoring Slow Queries
  • SQL Tuning
  • Table Partitioning
  • Operating System Best Practices
  • Parameter Tuning
  • Extensions
  • Monitoring Best Practices 
  • FDW and Sharding

·  

High Availability

  • Transaction Log Archiving 
  • Streaming Replication
  • Multimaster replication using pgpool
    • Installation
    • Configuration
    • Pool Setup
    • HA Setup

Databasease Upgrades

  • PostgreSQL Versioning
  • Plan for Upgrade
  • Upgrade using pg_dump
  • Upgrade using pg_upgrade
  • Post Upgrade Tasks
  • Upgrading replication cluster
  • Slony for upgrade