Objectives

  • Understand database migrations in general
  • Get an overview of tools that support PostgreSQL migrations
  • Key factors to consider when migrating to PostgreSQL
  • PostgreSQL data types
  • Logical Replication
  • Online and offline migrations
  • Loading data into PostgreSQL
  • Differences with other database systems

Method

  • Presentations, practical exercises, case studies and question-oriented demonstrations
  • Discussion and networking during breaks and lunch (included)

Target groups

  • This training to migrate to PostgreSQL is intended for DBAs and developers who would like to gain an in-depth understanding of PostgreSQL migrations.

Prerequisites

  • Be able to navigate on Linux shell
  • Have an understanding of databases
  • Have some knowledge of PostgreSQL
  • It is recommended to take the PostgreSQL DBA Essentials training before

5% discount for SOUG, SwissPUG and DOAG members.

Trainers

Thumbnail [150x150]

Daniel Westermann

Principal Consultant & Technology Leader Open Infrastructure