Certificate Authentication

Introduction
o Architectural Overview
o Lab Machine Setup
 

 Performance Monitoring and Tuning
o Monitoring Slow Queries
o SQL Tuning
o Table Partitioning
o Operating System Best Practices
o Parameter Tuning
o Usefull Extensions
o Benchmarking
o Monitoring Best Practices 
o Demos and Labs
 Indexes & Transaction Isolation levels
o Index types – BTREE, BRIN, GIST, GIN
o Isolation levels and locks
 

 Database Backups and Restores
o Logical or SQL Dump Backups
o Restoring SQL Dumps
o Physical Backups - Offline
o Restoring Offline Backups
o Physical Backups - Online
o Write Ahead Log(WAL) Archiving

o Recovery configuration
o Point in Time Recovery using WAL Archives
 

 Replication High Availability
o Transaction Log Archiving 
o Binary / Streaming Replication
o Repliacation parameters
o Slony
o Installation
o Configuration
o Demos and Labs
o PgPool & Replication Manager
 

 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
 

 Database Upgrades
o PostgreSQL Versioning
o Plan for Upgrade
o Upgrade using pg_dump
o Upgrade using pg_upgrade
o Post Upgrade Tasks