PGCon2017 - 20180510
PGCon 2017
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Christophe Pettus |
| Schedule | |
|---|---|
| Day | Tutorials - Day 2 & Unconference - 2017-05-24 |
| Room | DMS 1150 |
| Start time | 13:00 |
| Duration | 03:00 |
| Info | |
| ID | 1133 |
| Event type | Workshop |
| Track | Tutorial |
| Language used for presentation | English |
PostgreSQL When It is Not Your Job
Confidence in Your DevOps Role
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.