欧美福利在线播放_免费在线观看羞羞视频_加勒比色老久久爱综合网_性一交一乱一区二区洋洋av_国产麻豆麻豆_国产精品一线天粉嫩av_国产精品天美传媒入口_午夜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