日韩三级在线_国产精品3区_亚洲精品a_成人网页_国产成人精品久久_国产精品国产精品国产专区不片

   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