Course Outline
Foundations and Structure
- Overview of PostgreSQL structure: processes, memory usage, and file organization
- Organizing data: working with databases, schemas, and tablespaces
- Exploring the PostgreSQL toolset and system-level tables
Setup and Setup Configuration
- Process of installing PostgreSQL
- Working with configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Modifying key settings related to memory, logging, and connections
- Handling version upgrades and migrating existing installations
Managing Security
- Defining user roles, groups, and their associated privileges
- Reviewing authentication options: trust, password, MD5, and SCRAM
- Understanding Row-Level Security and data access policies
- Setting up SSL/TLS for secure connections
Data Protection and Restoration
- Creating logical backups using pg_dump and pg_restore
- Performing physical backups with pg_basebackup
- Implementing incremental backups and WAL archiving
- Executing full recoveries and Point-in-Time Recovery (PITR)
Monitoring and Upkeep
- Understanding how the autovacuum process works
- Conducting routine maintenance and analyzing logs
- Utilizing PgBadger for detailed log analysis
Requirements
A foundational understanding of 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.
