LinuxFest Northwest 2017: Database Automation; Using PostgreSQL and Linux Containers
Channel: linuxfestnorthwest
Date: 07/05/2017

COURSE DESCRIPTION: Automation is THE big thing these days. Software delivery and infrastructure changes in regards to provisioning, creating and tearing down servers, is no longer a niche activity for only the largest and most complex networks. Nowadays, everybody is racing to automate their environments and achieving an ever faster DEV-QA-PRODUCTION Life-Cycle. Better than ordinary application containers, OS containers are the best way to manage your PostgreSQL servers.


SYLLABUS/AGENDA: This talk describes and walks through the installation of the following technologies:
- The ZFS file system
- The Linux Container infrastructure
- Example containers i.e. Debian, Centos, Ubuntu etc
- The PostgreSQL RDBMS

LEARNING OBJECTIVES: We will demonstrate how easy PostgreSQL DBA tasks become in a virtual/cloud environment, including:
- Provisioning
- Replication
- Standby Servers
- Backups
- Snapshots
- Upgrades (binary and cluster)
- Rollbacks

WHO WILL GAIN THE MOST FROM THIS TRAINING:
  DEVOPS,
  Systems administrators,
  Full stack developer(s),
  Managers/team leaders

PREREQUISITES FOR THIS COURSE:
- DBA stuff (of course)
- Systems Administration (know your linux, be comfortable on the command line)
- Be comfortable compiling source code