Regular Admission - April 18 - 20
Admits one person to the main conference sessions on April 19 - 20, 2016, the Regulated Industry Summit on April 18th, and the 20th Anniversary Party on April 19th. Does *NOT* include any training sessions on April 18th.
Regulated Industry Summit ONLY - April 18
Admits one person to the Regulated Industry Summit on April 18th. Can also be presented for the 20th Anniversary Party on April 19th.
20th Anniversary Party ONLY - April 19th, 7:00pm
Come celebrate PostgreSQL turning 20!
Training: PostgreSQL When Its Not Your Job - April 18, 9:30AM
PostgreSQL has become the default database for most green-field development projects, and is the data storage architecture behind many success stories, such as Instagram. Despite a reputation as being complex and fiddly, Postgres is easy to install, administer, maintain, and use... with just a little bit of orientation. This is that orientation.
PostgreSQL has a reputation as being complex and hard to manage. It is certainly a powerful, capable database able to handle situations from a developer's laptop up to petabyte-sized installations. But that does not mean that only a special priesthood can operate it; any talented developer is capable of keeping a PostgreSQL installation healthy and happy.
We'll go through the tasks that encompass 90% of what you'll have to do with PostgreSQL, from installation, through basic server tuning, routine backups and maintenance tasks, basic disaster recovery, though query analysis and tuning, and tips and tricks to get maximum performance out of PostgreSQL.
We'll cover special situations, such as hosting on AWS, embedded/appliance environments, and the things you should never, ever do.
Presented by Christophe Pettus, PGExperts
Training: Steel Elephant: Creating and Managing a Highly Secure PostgreSQL Environment with HashiCorp's Vault and Consul - April 18, 9:30AM
This session will provide an in-depth walkthrough on how to setup Vault for use of securing the access of applications talking to PostgreSQL instances (both credentials and SSL certs) in a way that provides both revocability, auditability, and high-availability. This talk will include:
*) An in-depth tutorial for setting up consul and Vault in an HA cluster
*) Setting up an "App ID" Backend
*) Setting up a PKI backend
*) Integration of the "App ID" Backend into sample applications (JDBC, Rails, Python, and Go)
*) Benefits for administrators and Security Officers of the App ID backend
*) SSL Cert Management for encrypted connections from app hosts to databases
*) High-availability for failover of Vault and PostgreSQL across multiple data centers
Presented by Sean Chittenden, HashiCorp
Training: Out of the Box Replication in PostgreSQL 9.4
Most people use at least one 3rd party script/tool to manage Postgres replication for building reliable solution for mission critical Postgres databases. Postgres 9.4's new features allow users to setup replication using built in features without compromising reliability and remove reliance on 3rd party tools. In this tutorial, I will walk you through replication options available in Postgres 9.4, selecting the right solution to achieve your business requirements, and things to consider for monitoring and maintaining your setup in production. This is a hands on tutorial so please bring your laptop with you. I will share VMs in advance that will be used during tutorial to setup replication with Postgres 9.4.
Presented by Denish Patel, Medallia
Training: Introduction to PostGIS - April 18, 2:00PM
This workshop will cover the following topics:
What is PostGIS? and How to install it.
Fundamentals of the 2 core vector types geometry and geography including both 2D and 3D subtypes.
How to load data in geography and geometry.
How you can use PostGIS for spatial analysis to help answer questions about where and how far using
PostGIS proximity operators and functions including how to utilize new PostgreSQL 9.5 KNN enhancements.for both geometry and geography types
Visualizing answers to spatial questions with Open Source desktop spatial tools.
Using PostGIS to reshape spatial data.
Time permitting, or if enough interest, we'll also do some coverage of PostGIS tiger geocoder, pgRouting, and PostGIS raster.
We'll be using PostgreSQL 9.5+ and PostGIS 2.2 for this workshop, but most examples will work with PostGIS 2.1 and lower versions of PostgreSQL.
Presented by Leo Hsu and Regina Obe, Paragon Corporation
Training: Linux tuning to improve PostgreSQL performance: from hardware to postgresql.conf - April 18, 2:00PM
Linux operating system has lots of tuning options which can change performance of your PostgreSQL installation drastically. People often say that an Oracle DBA is 90% a DBA and 10% a UNIX engineer, for a Postgres DBA this correspondence can optimistically be 50:50 or even lower on the DBA part.
For PostgreSQL, obviously, most important are storage-related options like vm.dirty*, IO elevators or filesystem mount options, but there are many more of them: CPU scheduler options, NUMA settings, or even power saving policy.
The goal of this tutorial is to provide some guidelines how to chose proper hardware for a database server and explain to DBAs and engineers how to use all this settings in order to match hardware configuration and PostgreSQL workload.
Presented by Ilya Kosmodemiansky, PostgreSQL-Consulting LLC
Training: Elevating Your Confidence with PostgreSQL's Restoration Capabilities! - April 18, 2:00PM
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.
Presented by Joshua D. Drake, Command Prompt Inc.