Presented by:

Joshua D. Drake

Command Prompt, Inc.

Joshua (JD) is a long time Open Source advocate and entrepreneur dating back to the early days of Professional Open Source. From the valleys of Usenet he sold custom Linux servers with a whopping 16 MB of ram and 1GB SCSI drives. These were the days of SLS and many, many floppy disks. Through the years he has help found multiple Internet Service Providers as well as eventually launching his own firm, Command Prompt, Inc.. Command Prompt has over the years become one of the predominant privately owned PostgreSQL support and Consulting firms.

An avid public speaker and writer, he is also the founder of United States PostgreSQL, PgConf (PostgresConf) and More than a Refresh: A podcast about the most interesting people you haven't met. He currently resides off-grid in Montana.

He divides his time between Command Prompt, off-grid projects, mentoring/leadership roles and helping those who wish to become successful, define what that means for them.

No video of the event yet, sorry!

This half day training is fresh from being sold out at PgConf.eu. Fully updated with a comprehensive look at Point in Time Recovery and ZFS snapshots we will focus purely on the backup and restore of your data with PostgreSQL. In this training you will learn the nuances of PostgreSQL's built in backup and restore capabilities as well as external abilities brought about by technologies such as snapshots and pgBackrest. There will be instruction on pg_dump/all and restore including a full understanding of the different backup/restore formats, when to use them and how to reduce potential production issues running long backups. Lastly, the students will be shown how to use basebackups, PITR as well as filesystem snapshots and other well known utilities to properly manage the Elephant's data.

Date:
Duration:
30 min
Room:
Conference:
PGConf US 2016 [PgConf.US]
Language:
Track:
Operations
Difficulty:
Medium