PostgreSQL Administrator Training

Introduction

PostgreSQL system architecture

Introduction to various interfaces and tools

Tools. PgAdmin, phpPgAdmin, Visual Explain, Tora, Kexi, Rekall, OpenOffice

Complex queries and index creation

Query plan reading and data type selection

Overview of PostGIS extension

PostgreSQL history, current versions, website, resources

Administration

Performance Tuning

Data backup and rollback of data

Serverside Programming

Serverside Languages

Programming exercise in serverside Languages

Failover Solutions

Replication Concepts

PG_Dump and Restore Options

PITR Backup and Recovery

Extending PostgreSQL

HA Options

Slony

Connection Pooling

Upgrading PostgreSQL

Warm Standby/Log Shipping

Sharding and Scale Out

Futures and Features Road Map

See also

• PostgreSQL Training