PostgreSQL Administration 

Duration: 

3 Days

PostgreSQL Administration

​​

• Understand the PostgreSQL architecture

• Installing PostgreSQL from source

• Create databases

• Learn command line interface: psql

• Understand backup and restore 

• Create a hot standby database

• Understand the optimizer, statistics and vacuum

• Understand monitoring tools

• Upgrades in PostgreSQL

​

Monitoring PostgreSQL

Monitoring PostgreSQL

​

• Database Statistics

• The Statistics Collector

• Database Statistic Tables

• Operating System Process Monitoring

• Current Sessions and Locks

• Log Slow Running Queries

• Disk Usage

Duration: 2 Days

Backup and Recovery

Backup and Recovery 

​​

• Backup Types

• SQL Dump

• Cluster Dump

• Offline Copy Backup

• Continuous Archiving

• pg_basebackup

• Point-In Time Recovery

• pg_upgrade

Duration: 

2 Days

Configuration PostgreSQL

Configuration PostgreSQL

​​

• Setting PostgreSQL Parameters

• Access Control

• Connection Settings

• Security and Authentication

• Settings

• Memory Settings

• Query Planner Settings

• WAL Settings

• Log Management​

Duration: 

2 Days