课程概览
此培训专为希望学习在Postgre SQL实现高可用性和Database安全性的工具和技术的Database管理员和架构师而设计。
您还将学习如何查找慢查询,监视数据库性能以及调整Postgre SQL for Performance。
课程大纲
· Introduction
· Database Security
o Users and Groups
o Access Control
o Row Level Security
o Host Based Access Control
o Data Encryption using pgcrypto
o Demos and Labs
· Performance Monitoring and Tuning
o Monitoring Slow Queries
o SQL Tuning
o Table Partitioning
o Operating System Best Practices
o Parameter Tuning
o Extensions
o Benchmarking
o Monitoring Best Practices
o Demos and Labs
· High Availability
o Transaction Log Archiving
o Streaming Replication
o Connection Pooling and HA setup using pgpool-II
§ Installation
§ Configuration
§ Pool Setup
§ HA Setup
o Demos and Labs
· Database Upgrades
o PostgreSQL Versioning
o Plan for Upgrade
o Upgrade using pg_dump
o Upgrade using pg_upgrade
o In Place or Not-in Place Upgrade
o Post Upgrade Tasks