Course Outline
Introduction and System Architecture
- Overview of PostgreSQL architecture: internal processes, memory structures, and file systems
- Structuring data: working with databases, schemas, and tablespaces
- Exploring the PostgreSQL toolset and system catalogs
Installation and Setup
- Installing the PostgreSQL server
- Reviewing key configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Tuning essential parameters related to memory, logging, and connection limits
- Processes for upgrading and migrating existing PostgreSQL installations
Security Administration
- Managing user roles, groups, and granular privileges
- Exploring authentication mechanisms: trust, password, MD5, and SCRAM
- Introduction to Row-Level Security and data access control policies
- Implementing SSL/TLS encryption
Backup Strategies and Recovery
- Creating logical backups using pg_dump and restoring with pg_restore
- Performing physical backups via pg_basebackup
- Implementing incremental backups and WAL archiving
- Executing full recovery and Point-in-Time Recovery (PITR)
Monitoring and Upkeep
- Comprehending the autovacuum mechanism
- Carrying out routine maintenance and analyzing server logs
- Leveraging PgBadger for detailed log insights
Requirements
Familiarity with basic SQL concepts is required
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 versatility of the training.
