The course aims to describe the installation and configuration of PostgreSQL and understand the main components of the DB.

In the first phase (BASIC), the fundamental commands for managing the DB will be introduced, user management policies will be defined, and backup operations will be described.

In the second phase (ADVANCED), high reliability and upgrade procedures will be discussed, and best practices for DB tuning and performance optimization will be described.

Program

Day 1-2 (2 modules of 4 hours)

•  Introduction – PostgreSQL theory
• Differences between PostgreSQL and other SQL databases
• Installation of PostgreSQL (rpm and binary)
• Initial configuration
• Analysis of the datadir and the most significant configuration files
• Inside PostgreSQL – most important commands and shortcuts
• Users, schema, login, security
• Logical backup and restore

Day 3-4 (2 modules of 4 hours)

• Physical backup and restore
• HA streaming replication
•  HA PGPOOL II
• Minor and major release upgrades Basic performance & tuning