Course Materials

• Slides-v3.0

• Activity Guide - v11

Introduction to PostgreSQL Server

• Introduction to PostgreSQL Server

PostgreSQL Server Architecture

• Instance : Process Structures

• Instance : Memory Structures

• Database Cluster

Installing PostgreSQL

• Links to download pre-built Linux VM

• Overview of PostgreSQL Server Installation

• Lab : Installing PostgreSQL Server

PostgreSQL Server Default Databases

• About Default Databases

PostgreSQL Server File Layout

• PostgreSQL Server File Layout

psql

• About psql

• Lab : Using psql

Starting/Stopping PostgreSQL Server

• About Startup and Shutdown of PostgreSQL Server

• Lab : Starting & Stopping PostgreSQL Server

System Catalogs and System Views

• About System Catalogs and System Views

• Lab : System Catalogs and System Views

Server Configuration

• About PostgreSQL Server Configuration

• Lab : Server Configuration

Client Authentication

• About Client Authentication

• Lab : Configuring Client Authenticaion

Database Roles and Privileges

• About Login Roles

• About Privileges

• About Group Roles

• Lab : Managing Roles and Privileges

Managing Schemas

• About Managing Schemas

• Lab : Managing Schemas

Managing Databases

• About Managing Databases

• Lab : 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