   PostgreSQL Advanced DBA培訓

Introduction
Architectural Overview
Lab Machine Setup

Performance Monitoring and Tuning
Monitoring Slow Queries
SQL Tuning
Table Partitioning
Operating System Best Practices
Parameter Tuning
Extensions
Benchmarking
Monitoring Best Practices
Demos and Labs

Database Backups and Restores
Logical or SQL Dump Backups
Restoring SQL Dumps
Physical Backups - Offline
Restoring Offline Backups
Physical Backups - Online
Write Ahead Log(WAL) Archiving
Recovery configuration
Point in Time Recovery using WAL Archives

High Availability
Transaction Log Archiving
Streaming Replication
Connection Pooling and HA setup using pgpool-II
Installation
Configuration
pgpool Setup
HA Setup
Demos and Labs

Database Security
Users and Groups
Access Control
Row Level Security
Host Based Access Control
Data Encryption using pgcrypto
Demos and Labs

Database Upgrades
PostgreSQL Versioning
Plan for Upgrade
Upgrade using pg_dump
Upgrade using pg_upgrade
In Place or Not-in Place Upgrade
Post Upgrade Tasks