Course Outline
Introduction and Architecture
- High-level view of PostgreSQL architecture, including processes, memory structures, and file systems
- Data organization concepts: databases, schemas, and tablespaces
- Introduction to the PostgreSQL toolkit and system catalogs
Installation and Configuration
- Procedures for installing PostgreSQL
- Reviewing key configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Optimizing core parameters related to memory, logging, and connection limits
- Strategies for upgrading and migrating PostgreSQL environments
Security Management
- Managing user roles, groups, and granular privileges
- Exploring authentication mechanisms: trust, password, MD5, and SCRAM
- Introduction to Row-Level Security and data access policies
- Implementation of SSL/TLS encryption
Backup and Recovery
- Performing logical backups and restores using pg_dump and pg_restore
- Executing physical backups via pg_basebackup
- Managing incremental backups and Write-Ahead Log (WAL) archiving
- Implementing full recovery and Point-in-Time Recovery (PITR)
Monitoring and Maintenance
- Comprehending the autovacuum mechanism
- Conducting routine maintenance and performing log analysis
- Leveraging PgBadger for detailed log insights
Requirements
Fundamental proficiency in SQL
Testimonials (7)
A good first contact with a new database technology
Cont Florian - Banca Transilvania Cluj
Course - PostgreSQL Server Administration
I know another way of upgrading the postgres except using logical backups and many more ...
Krasimir Troskov - Banca Transilvania Cluj
Course - PostgreSQL Server Administration
getting knowledge about new DB flavour .
Adrian Ionut Chelaru - Banca Transilvania Cluj
Course - PostgreSQL Server Administration
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.
