Training Signup/Purchase
Bruce Momjian's Introduction to Postgres Administration
This class is designed for people developing, deploying, or already running Postgres in production.
In this course you will learn the essential details of Postgres configuration, security, maintenance, monitoring, tuning, backups, recovery, and moving data. These classes convey the knowledge necessary for the student to perform their duties as a Postgres DBA, and are a foundation for the Advanced and Performance courses that follow in the DBA track. This course is designed for people with experience in database administration but who are new to the Postgres platform.
During the 4 days of instruction, participants will cover the following topics:
Day 1
- Introduction
- PostgreSQL System Architecture
- Installation
- Configuration
- Creating and Managing Databases
- Introduction to PSQL
- pgAdmin III
- Security
- SQL
- Data Handling
- Backup and Recovery
- Routine Maintenance
- Postgres Data Dictionary
- Moving Data
- Monitoring and Statistics
- Performance Tuning
- Procedural Languages
