Introduction to PostgreSQL 9 Database Administration

The class covers the tasks that a PostgreSQL database administrator faces daily, from basic operations to advanced techniques. Course notes use pgAdmin as a graphical administration tool.

Course Length: 1 day

Who Should Attend:

Database administrators, systems administrators, or developers who are familiar with databases, but not PostgreSQL.


Students must have a working knowledge of SQL and database basics.

Course Outline:

  • Connecting & Troubleshooting

  • PgAdmin III Overview

  • Server Configuration

  • Database Administration

  • User Administration

  • Understanding Database Object Types

  • Permissions & Security

  • Running SQL

  • Monitoring


  • Maintenance

  • Data Migration & Test Environments

  • Server Log

  • Help & Support

Benefits of Attendance:

Upon completion of this course, students will be able to:

  • Start and stop a PostgreSQL server

  • Change the configuration of the database

  • Create users and restrict what they are able to do

  • Execute SQL queries on the server

  • Monitor database activity and statistics

  • Understand what background maintenance the database does automatically

  • Setup a test environment with sample data

  • Look for problems in the server's log files

  • Find the free and commercial resources for PostgreSQL issues

PostgreSQL Case studies

Mind Candy logo

Mind Candy

Zero to 50m users in 3 years is a steep curve. 2ndQuadrant stepped in to help with a monster database...

PostgreSQL Books

PostgreSQL 9 Administration Cookbook

PostgreSQL 9 Administration Cookbook

A practical guide, this cookbook will ensure you run a smooth PostgreSQL database.

PostgreSQL 9.0 High Performance

PostgreSQL 9.0 High Performance

A clear, step-by-step guide to optimizing and scaling up PostgreSQL database servers.

Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.

Cookie Settings

2ndQuadrant Updates