PostgreSQL 9.4 Administration

Training Architect
course instructor image
Terrence Cox
A veteran of twenty years in Information Technology in a variety of roles. He has worked in development, security and infrastructure well before they merged into what we now call DevOps. He provides training in Linux, VMWare, DevOps (Ansible, Jenkins, etc) as well as containers and AWS topics.


Installation and Configuration

Exercise: Install and Configure PostgreSQL 9.x: RHEL/CentOS


Exercise: Install and Configure PostgreSQL 9.x: Debian/Ubuntu


Administration and Security

Exercise: Creating and Deleting Databases and Adding Users


Exercise: Create a Table and Inserting Data


Exercise: Configure the Database for External Connections


Exercise: Database Backup and Restore





Understanding open source RDBMS systems is an important skill for a successful system administrator or engineer.

This course will help you gain a deep understanding of how to install and coonfigure PostgreSQL v9.4. Once you have the server itself, we will take a look at creating users that can access our RDBMS and setting up a basic schema, as well as how to create basic replication and do simple backup/restore.

Finally, we will show you how to build and work with that schema in order to understand data types, inserting, updating and deleting records.

Study Guides

Instructor Deck


certificate ribbon icon

Earn a Certificate of Completion

When you complete this course, you’ll receive a certificate of completion as proof of your accomplishment.

Looking For Team Training?

Learn More