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.

Prerequisiti Argomenti Capacità acquisite

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.

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

Durata: 5.00 giorni

Tieniti in contatto con noi.

Iscriviti alla nostra newsletter trimestrale: riceverai le ultime notizie su 2ndQuadrant e aggiornamenti sulle tecnologie da noi supportate

La tua privacy è tutelata in base alla normativa vigente (art. 13 D. Lgs. 30.06.2003, n. 196).