PostgreSQL Advanced Administration Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français - Veuillez noter que ce cours est uniquement disponible en anglais.This PostgreSQL Advanced Administration course covers database upgrades,database security,table partitioning,and both streaming r PostgreSQL Advanced Administration Training Course Course Contents - DAY 1 Course Introduction Administration and Course Materials Course Structure and Agenda Delegate and Trainer Introductions Session 1: DATABASE UPGRADES PostgreSQL Versioning Plan an Upgrade Upgrade using pg_dump Upgrade using pg_upgrade Post Upgrade Tasks Overview of upgrading using Logical Replication Session 2: DATABASE SECURITY Client Authentication Control Password handling User and Role management Row Level Security Encryption Options Encrypt Specific Columns with the pgcrypto Module The Performance Implications of Encryption Session 3: CONTROL ACCESS TO THE SERVER Secure TCP/IP Connections with SSL Secure TCP/IP Connections with SSH Tunnels PostgreSQL Advanced
