PostgreSQL Administration Training


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


In preparation for this training session, a VirtualBox Image is available for download below ( 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:

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.

Room 106
Thursday, March 8, 2018 - 10:00 to 17:00