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
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.