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.

Trainers

Thumbnail [150x150]

Joël Cattin

Principal Consultant

Thumbnail [150x150]

Daniel Westermann

Delivery Manager & Technology Leader