Course Outline
Introduction and Architecture
- Overview of PostgreSQL architecture: processes, memory management, and file systems.
- Data structuring: understanding databases, schemas, and tablespaces.
- Familiarisation with the PostgreSQL toolset and system catalog tables.
Installation and Configuration
- Process of installing PostgreSQL instances.
- Managing configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf).
- Tuning core parameters related to memory, logging, and connection limits.
- Strategies for upgrading and migrating existing PostgreSQL installations.
Security Management
- Defining user roles, groups, and specific privileges.
- Implementing authentication methods: trust, password, MD5, and SCRAM.
- Introduction to Row-Level Security and defining data access policies.
- Setting up and configuring SSL/TLS encryption.
Backup and Recovery
- Performing logical backups using pg_dump and restoring via pg_restore.
- Creating physical backups with pg_basebackup.
- Managing incremental backups and WAL archiving strategies.
- Executing full recovery and Point-in-Time Recovery (PITR) scenarios.
Monitoring and Maintenance
- Comprehending the autovacuum process and its impact on database performance.
- Carrying out routine maintenance tasks and analysing logs.
- Utilising PgBadger for advanced log analysis and troubleshooting.
Requirements
A fundamental understanding of SQL syntax and concepts.
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.
