PostgreSQL Immersion

The PostgreSQL Immersion course combines a selection of topics from two other comprehensive courses (Administration and Replication, Backup & Disaster Recovery) as a self-contained program. This course has minimal prerequisites, making it ideal as a speedy introduction to PostgreSQL. It is suitable for a wide range of attendees such as database administrators having prior experience with any database software.

Prerequisites Topics Acquired skills

Students must have a working knowledge of SQL. The ability to use the command line interface to a Linux system and some basic UNIX shell programming experience is needed to complete all of the replication workshop exercises.

Who should attend?

Database administrators, systems administrators, or developers with working knowledge of database usage.

Introduction to PostgreSQL

Server Configuration

Database Administration

User Administration

Understanding Database Object Types

Permissions & Security


VACUUM, Freezing & Avoiding Wraparound


Logical Backup

Replication Overview

Replication Terminology

Replication Transport

Replication Startup & Setup

Disconnection and Reconnection

Switchover, Failover and Failback

Physical Streaming Replication


Logical Streaming Replication & pglogical

Bi-Directional Replication

Logical Decoding

Online Upgrade

Connection Pooling

Sharding and Scale Out

Physical Backup

Point In Time Recovery


A solid understanding of PostgreSQL across a wide range of areas covering best practices and some aspects of PostgreSQL internals, from Database Administration and Replication, Backup and Disaster Recovery concepts.

Tags: Introduction to PostgreSQL 9 Database Administration, PostgreSQL 9 Replication & Recovery Concepts

Length: 5.00 days

Upcoming related events

Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.