PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Steve Singer |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - 2013-05-24 |
| Room | MRT 256 |
| Start time | 11:30 |
| Duration | 01:00 |
| Info | |
| 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.