Course Outline
Introduction and Architecture
- Overview of PostgreSQL architecture: processes, memory, and file structures
- Organizing data: databases, schemas, and tablespaces
- The PostgreSQL toolset and system tables
Installation and Configuration
- Installing PostgreSQL
- Working with configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Tuning core parameters (memory, logging, and connections)
- Upgrading and migrating PostgreSQL deployments
Security Management
- Managing user roles, groups, and privileges
- Authentication mechanisms: trust, password, MD5, and SCRAM
- Introduction to Row-Level Security and data access policies
- Setting up SSL/TLS encryption
Backup and Recovery
- Creating logical backups using pg_dump and pg_restore
- Generating physical backups with pg_basebackup
- Managing incremental backups and WAL archiving
- Full recovery and Point-in-Time Recovery (PITR)
Monitoring and Maintenance
- Comprehending the autovacuum process
- Performing routine maintenance and analyzing logs
- Leveraging PgBadger for detailed log analysis
Requirements
Fundamental proficiency in SQL
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 way in which known concepts and examples and exercises are related to make the topic at hand clearer
Jesus Eduardo Hornedo Flores - BOZ IT DEVELOPMENT SA DE CV
Course - PostgreSQL for Administrators - 2 Days
Machine Translated
