PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Christophe Pettus
Day Talks - 2 - Friday - 2012-05-18
Room MRT 218
Start time 13:30
Duration 01:00
ID 419
Event type Lecture
Track DBA
Language used for presentation English

PostgreSQL on AWS

EC2 with somewhat reduced tears

Amazon Web Services (AWS) has become a very popular platform for deploying PostgreSQL-backed applications. But it's not a standard hosting platform. We'll talk about how to get PostgreSQL to run efficiently and safely on AWS.

Among the topics covered will be:

-- Selecting an EC2 instance size, and configuring it for PostgreSQL. -- Dealing with ephemeral instance storage: What is it good for? How much do you need? -- Elastic Block Store: How much do you need? How do you configure it for best performance? -- AWS characteristics and quirks. -- Why replication is not optional on AWS. -- Backups and disaster recovery.