Training agenda
- PostgreSQL 14 database server architecture and configuration
- Database server management (installation, upgrade, initialisation, starting, stopping)
- Physical and logical server structures (databases, tablespaces, schemas)
- Vacuum, Analyze, Reindex operations
- Security management (roles, privileges)
- Database server monitoring (logs, Statistics Collector, auditing)
- Protecting databases from failures (logical and physical backups, Disaster Recovery)
- Database replication mechanisms (standard physical and logical replication)
- Overview of query optimisation topics and performance management (Query Planner, statistics, configuration, execution plans)