課程大綱： 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
加入高級會員獲得助教答疑
