Preview unavailable

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 PostgreSQL1

• Lab Practice: Installing PostgreSQL on Linux1

PostgreSQL File Layout

• PostgreSQL File Layout1

Using psql

• Using psql

Starting/Stopping PostgreSQL Server

• Overview of Starting/Stopping PostgreSQL Server

• Lab Practice: Starting/Stopping the PostgreSQL Server2

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