Skip site navigation (1) Skip section navigation (2)

PostgreSQL DBA Hands-on Training

Date: 2016-11-07 – 2016-11-10
Location: Las Vegas, NV, United States
Language: English

I. Getting Started

  1. Installing PostgreSQL
  2. Compiling and Installing PostgreSQL on Linux/Unix
  3. Post-Installation Setup *The PostgreSQL Windows Installer

  4. Creating a Database and Testing the Server

  5. Initializing a Cluster
  6. Creating a Database
  7. Starting the Database Server
  8. The psql Client
  9. Startup Failures and Client Connection Problems

II. Basic PostgreSQL Administration

  1. Overview of PostgreSQL Architecture
  2. Configuration Files
  3. Physical Storage and File Layout
  4. Tablespaces
  5. System Catalogs
  6. Logging Parameters

  7. Roles and Privileges

  8. Roles and Their Attributes
  9. Privileges
  10. Role Membership

  11. Security

  12. Securing TCP Connections with SSL
  13. Create Secure SSH Tunnels
  14. Client Authentication
  15. Encryption Options

  16. Backup and Recovery

  17. Overview of Backup Methods
  18. Performing an SQL Dump and Restore
  19. Filesystem Backup

  20. Maintenance and Monitoring

  21. Routine Maintenance Tasks
  22. Monitoring Database Activity
  23. Monitoring Disk Usage

  24. Client Connections

  25. pgsqlODBC and OpenOffice
  26. Windows ODBC and Microsoft Access
  27. Perl DBI

III. Advanced Administration Topics

Prerequisite knowledge

This course requires students to have understanding of Linux fundamentals as well as SQL.

To visit please register OR CALL: 630-684-0355

Posted by CertFirst (

Note: The PostgreSQL Global Development Group does not endorse any events run by third parties. No guarantee of the quality of events is offered whatsoever.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group