Maintenance, monitoring and version upgrades: VACUUM, autovacuum, alerts and pg_upgrade

1 h 10 min Debian 13 Versions PostgreSQL 15 à 18, MariaDB 10.11 à 11.8, postgres_exporter, mysqld_exporter

Objective

Keep a database healthy over time: cleaning and freezing PostgreSQL tables, alerts that warn you before the incident, and version upgrades prepared as risky operations.

This lesson is part of the full course

Unlock Database administration: MariaDB, MySQL and PostgreSQL in production to read every lesson, do the exercises, access the simulations and earn your certificate.

Buy — $19 All-access pass — $99

Already enrolled? Log in.