Course Outline
Foundations and Architecture
- Overview of PostgreSQL architecture: including processes, memory allocation, and file structures
- Organizing data: covering databases, schemas, and tablespace management
- The PostgreSQL utility set and internal system tables
Deployment and Configuration
- Steps for installing PostgreSQL
- Reviewing configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Tuning key parameters related to memory, logging, and connections
- Processes for upgrading and migrating existing PostgreSQL setups
Security Administration
- Defining user roles, groups, and access privileges
- Exploring authentication techniques: trust, password, MD5, and SCRAM
- Introduction to Row-Level Security and data access regulations
- Setting up SSL/TLS encryption
Backup Strategies and Recovery
- Creating logical backups using pg_dump and restoring with pg_restore
- Generating physical backups via pg_basebackup
- Implementing incremental backups and archiving Write-Ahead Logs (WAL)
- Achieving full recovery and Point-in-Time Recovery (PITR)
Monitoring and System Maintenance
- Comprehending the autovacuum mechanism
- Conducting regular maintenance tasks and reviewing logs
- Leveraging PgBadger for detailed log analysis
Requirements
Fundamental proficiency with SQL syntax
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.
