PostgreSQL Database Administration
- Buy now
- Learn more
Course Materials

Slides-v2.0
Activity Guide - v10.0
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
How to Create Second Database Cluster on same Host?
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

WAL and WAL Archiving
Control File

Control File
Vacuuming

Vacuuming
Backup and Recovery

Overview of SQL Dump
Lab Practices: SQL Dumps
Continuous Archivining, Base Backup & Reovery
Lab Practices: Continuous Archiving, Base Backup and Recovery
Upgrading PostgreSQL Server

Download DVDRENTAL database (dvdrental.zip)
Instructions to restore DVDRENTAL database from Archive
Overview of Upgrading PostgreSQL Server
Lab Practice: Upgrading PostgreSQL Server
Deploying Multiple Clusters on the same Host

How to deploy Multiple Clusters?
De-installing PostgreSQL Server
Installing PostgreSQL Server on Windows

How to Install PostgreSQL Server on Windows?
Deinstalling PostgreSQL Server

How to Deinstall PostgreSQL Server on Windows and Linux?
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 File Layout

2 Lessons