Introduction
This practical tutorial will guide you through the complete process of PostgreSQL installation, providing you with the necessary skills to operate PostgreSQL in a realistic production environment.
We will begin by installing and configuring PostgreSQL on Linux. After the basic setup, we will perform tuning based on the resources of the VM and explore useful system views. Following this, we will set up pgBouncer and learn how to operate it. Next, we will configure backup and recovery infrastructure using pgBackRest and set up a physical replica. The final step will take you through a major upgrade process using the pg_upgrade tool.
This is a practical tutorial: each participant will receive a VM image for a comprehensive hands-on experience.
Audience:
- Database administrators who are new to PostgreSQL (both beginners and DBAs with experience in alternative databases)
- Developers interested in learning more about PostgreSQL administration
Prerequisites:
- Basic knowledge of the Linux command line
- A laptop capable of running 3 VMs 1-4GB RAM and 10-20GB disk space each.
