PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

Steve Singer
Day Talks - Day 2 - 2013-05-24
Room MRT 256
Start time 11:30
Duration 01:00
ID 540
Event type Lecture
Track DBA
Language used for presentation English

Elephant Puppets

Deployment automation for PostgreSQL

Puppet is a platform for I.T. automation and configuration management that has gained popularity in the devops movement. This talk will provide an introduction to puppet and talk about how Afilias uses puppet to deploy and maintain over one hundred servers running PostgreSQL that support key parts of the DNS infrastructure

Puppet allows DBA's to automate the installation and configuration of PostgreSQL across multiple servers. This talk will explain how puppet can be used to install and configure PostgreSQL. Automated configuration of your database servers keeps servers looking the same allowing you to control differences. Managing your database servers through puppet also allows your to easily reproduce your configuration for development and QA purposes.

The talk will cover the basics of puppet and best practices for deploying puppet to manage PostgreSQL including:

  • How to install PostgreSQL via puppet and create database clusters
  • How to manage postgresql.conf, pg_hba.conf and .pgpass via puppet
  • Best practices for dealing with configuration differences between different database servers and different environments

Afilias is a registry services provider running registries for numerous TLDs including: .INFO, .ORG, .MOBI, .XXX, .IN, .ME, .ASIA, .MOBI. Afilias has been using PostgreSQL since the 7.x days and currently has more 100 production database servers running PostgreSQL.