Course Outline
Overview and Architecture
- Summary of PostgreSQL architecture: processes, memory structures, and file systems
- Structuring data: databases, schemas, and tablespace management
- Exploring the PostgreSQL toolkit and system-level tables
Deployment and Setup
- Installation procedures for PostgreSQL
- Reviewing configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Tuning essential parameters (memory allocation, logging, connection limits)
- Handling version upgrades and database migrations
Security Administration
- Managing user roles, groups, and access privileges
- Authentication mechanisms: trust, password, MD5, SCRAM
- Introduction to Row-Level Security and data access policies
- Implementing SSL/TLS security
Backup Strategies and Recovery
- Logical backup methods using pg_dump and pg_restore
- Physical backup techniques via pg_basebackup
- Handling incremental backups and WAL archiving
- Full restoration and Point-in-Time Recovery (PITR)
Surveillance and Upkeep
- Comprehending the autovacuum mechanism
- Regular maintenance tasks and log interpretation
- Applying PgBadger for detailed log analysis
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.
