PostgreSQL Database Administration
- Buy now
- Learn more
Course Materials

Slides-v2.0
Activity Guide - v11
Introduction to PostgreSQL Server

Introduction to PostgreSQL Server
PostgreSQL Server Architecture

PostgreSQL Server Architecture
Installing PostgreSQL

Links to download pre-built Linux VM
Overview of Installing PostgreSQL
Lab Practice: Installing PostgreSQL on Linux
PostgreSQL File Layout

PostgreSQL File Layout
Using psql

Using psql
Starting/Stopping PostgreSQL Server

Overview of Starting/Stopping PostgreSQL Server
Lab Practice: Starting/Stopping the PostgreSQL Server
System Catalogs and System Views

About System Catalogs and System Views
Lab Practice: System Catalogs and System Views
Server Configuration

About Server Configuration Settings
Lab Practice: Server Configuration Settings
Client Authentication

Overview of Client Authentication
Lab Practice: Configuring Client Authentication
Database Roles and Privileges

About Roles
About Privileges
About Groups
Lab Practices: Roles, Privileges, Groups
Managing Schemas

Overview of Managing Schemas
Lab Practice: Managing Schemas
Managing Databases

Overview of Managing Databases
Lab Practices: Managing Databases
Managing Tablespaces

Overview of Managing Tablespaces
Lab Practices: Managing Tablespaces
Write-Ahead Log (WAL) and WAL Archiving

Overview of WAL and WAL Archiving
Lab Practices: WAL and Configuring WAL Archiving
Control File

Control File
Vacuuming

Vacuuming
Backup and Recovery

Overview of Backup and Recovery
Lab Practices: Backup and Recovery
Upgrading PostgreSQL Server

Overview of Upgrading PostgreSQL Server
Lab Practice: Upgrading PostgreSQL Server
Deinstalling PostgreSQL Server on Linux

Deinstalling PostgreSQL Server on Linux
Deploying Multiple Clusters on the same Host

Creating Second Database Cluster
Installing different version of PostgreSQL Server
PostgreSQL Server on Windows

Installing PostgreSQL Server on Windows
Deinstalling PostgreSQL Server on Windows
Replication

Overview of PostgreSQL Replication
Streaming Replication
Links to download pre-built VMs
Lab Practice: Implementing Streaming Replication
Overview of Logical Replication
Lab Practice: Implementing Logical Replication

PostgreSQL Server on Windows

2 Lessons