Do you have PostgreSQL databases in your IT environment and want to learn database administration best practices to get the most out of PostgreSQL? If you want to know more about backup and recovery strategies for PostgreSQL, then our PostgreSQL DBA training is for you. At the end of this course, you will be familiar with PostgreSQL architecture, DBA best practices for PostgreSQL and the various high availability options. You will also be able to set up a standby database and know how to run backups safely.
Objectives
- Understand the PostgreSQL architecture
- How PostgreSQL organizes files on disk
- Install PostgreSQL from source
- Understand what is common and what is different from other databases such as Oracle
- Creating databases
- Get used to the command line interface: psql
- Understand backup and restore procedures in PostgreSQL
- Understand the monitoring tools
- Create a hot standby database
- Understand PostgreSQL high availability options
- Understand the optimizer, statistics and vacuum
- Upgrading PostgreSQL
Method
- Presentations, practical exercises, case studies and question-oriented demonstrations
- Discussion and networking during breaks and lunch (included)
Target groups
- This PostgreSQL DBA Essentials training course is designed for database administrators (DBAs) as well as network, system and application administrators.
Prerequisites
- Be able to navigate on Linux shell
- Have basic knowledge of databases.
5% discount for SOUG, SwissPUG and DOAG members.