亚洲国产婷婷六月丁香,亚洲av永久中文无码精品 ,亚洲av成人精品一区二区三区,亚洲av无码乱码在线观看富二代,亚洲av乱码一区二区三区香蕉

課程目錄:PostgreSQL Advanced DBA培訓(xùn)
4401 人關(guān)注
(78637/99817)
課程大綱:

   PostgreSQL Advanced DBA培訓(xùn)

 

 

 

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