PostgreSQL Administration Training
Keith Fiske
Audience:
Beginner
Topic:
PostgreSQL

This session will be a hands-on training session for setting up a PostgreSQL database from scratch using CentOS7. Included topics will be:

  • Package installation
  • Cluster initialization
  • Service management
  • Backup & Restore
  • Replica setup
  • Failover

Prerequisites

In preparation for this training session, a VirtualBox Image is available for download below (PGTraining_VM.zip). VirtualBox version 5.2 is required (5.2.6 as of this writing) as well as the Oracle VM VirtualBox Extension Pack, both of which can be downloaded from Oracle's website: https://www.virtualbox.org/wiki/Downloads

To import the VM, follow these steps:
1. Extract the zip file (requires roughly 8GB)
2. Open VirtualBox and go to the top menu: Machine -> Add...
3. Browse to the extracted folder and select "PG Training - CentOS7.vbox"

You should be able to start the VM from there. With the extensions pack installed, bidirectional copy-n-paste should work. Snapshots are also available to reset the VM back to the original image.

Presentation Link:
PostgreSQL Administration
Room:
Room 106
Time:
Thursday, March 8, 2018 - 10:00 to 17:00