Skip to content

PostgreSQL DBA Essential

Run PostgreSQL to DBA best practices, set up a standby database, back up safely and know your high availability options.

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.

Overview

Database · Open Source

Duration

2 Day(s)

Price

1800 CHF

Tue 19 – Wed 20 Jan 2027

Location

Nyon

Language

French

No places available

Tue 26 – Wed 27 Jan 2027

Location

Basel

Language

English

No places available

Tue 26 – Wed 27 Jan 2027

Location

Zurich

Language

English

No places available

Tue 26 – Wed 27 Jan 2027

Location

Bern

Language

English

No places available

Tue 27 – Wed 28 Apr 2027

Location

Basel

Language

English

No places available

Tue 27 – Wed 28 Apr 2027

Location

Zurich

Language

English

No places available

Tue 27 – Wed 28 Apr 2027

Location

Bern

Language

English

No places available

Tue 18 – Wed 19 May 2027

Location

Nyon

Language

French

No places available

Taught by the people who run it in prod.

Adrien Obernesser

Adrien Obernesser

Consultant

Vincent Houriet

Vincent Houriet

Consultant