Course Outline
Introduction and Architecture
- Overview of PostgreSQL architecture, including processes, memory, and file structures
- Understanding data organisation through databases, schemas, and tablespaces
- Familiarising with the PostgreSQL toolset and system tables
Installation and Configuration
- Processes for installing PostgreSQL
- Managing configuration files, including postgresql.conf, postgresql.auto.conf, pg_hba.conf, and pg_ident.conf
- Tuning core parameters related to memory, logging, and connections
- Strategies for upgrading and migrating PostgreSQL installations
Security Management
- Handling user roles, groups, and privilege assignments
- Applying authentication methods such as trust, password, MD5, and SCRAM
- Understanding Row-Level Security and data access policies
- Implementing SSL/TLS configurations
Backup and Recovery
- Creating logical backups using pg_dump and restoring with pg_restore
- Performing physical backups with pg_basebackup
- Implementing incremental backups and WAL archiving strategies
- Executing complete recovery and Point-in-Time Recovery (PITR)
Monitoring and Maintenance
- Gaining insight into the autovacuum process
- Carrying out routine maintenance and analysing logs
- Utilising PgBadger for detailed log analysis
Requirements
A foundational understanding of SQL is required.
Testimonials (7)
The patiance and the style of teaching of Michał was nice.
Luiza
Course - PostgreSQL for Administrators - 2 Days
Michal was great at sharing his vast knowledge of postgres.
Matei
Course - PostgreSQL for Administrators - 2 Days
The training was interactive which made it interesting.
Priyanka Talwar - University of South Australia
Course - PostgreSQL for Administrators - 2 Days
Great lab setup. Very practical training which reinforced the material.
Brian - Verizon Connect
Course - PostgreSQL for Administrators - 2 Days
Practical exercises and suggestions given by the trainer.
Bruno - Verizon Connect
Course - PostgreSQL for Administrators - 2 Days
interaction was encouraged,Very useful practical approaches.
Farhan - Fast Lane Consulting and Education Services Limited
Course - PostgreSQL for Administrators - 2 Days
The versatility of the training.
