PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX, and Windows.

In the PostgreSQL Administration training course attendees learn the essential skills for PostgreSQL Administration including: PostgreSQL architecture, configuration, maintenance, monitoring, backup, recovery and data import/export.

Target audience: This module is suitable for DBAs, Data Architects, IT Managers, IT Directors, IT Strategists, System Administrators and GIS Professionals. It is designed to convey the knowledge necessary to perform duties comparable to those of a PostgreSQL Database Administrator.

Prerequisites: No prior knowledge of PostgreSQL is required. Basic experience with Linux and any database product is recommended.


Course outline:

  • Installation
  • Database Management
  • Architecture
  • Roles
  • Schemas, Tablespaces, Partitions, Views, Indexes
  • Log Files
  • Configuration
  • Security
  • Contrib Modules
  • Statistics
  • PGAdmin
  • The Data Dictionary
  • Languages
  • Triggers, Rules
  • Logical Backups, Physical Backups, Point In Time Recovery (PITR)
  • Moving Data
  • Routine Maintenance
  • Supported PostgreSQL