PGCon2010 - Final Release III

PGCon 2010
The PostgreSQL Conference

Josh Berkus
Day Tutorials - 1 - 2010-05-18
Room DMS 1110
Start time 13:00
Duration 03:00
ID 223
Event type Workshop
Track Tutorial
Language used for presentation English

Server Health Check

Give your Postgres server a checkup

Have you given your PostgreSQL database server a checkup lately? If not, you probably should. "Sick" database servers are easy to prevent if you take a few simple steps <i>before</i> your server comes down with something.

Just as regular doctor's checkups help spot disease and chronic health problems in people before they become acute, a "health check" of your PostgreSQL servers will uncover and sometimes prevent database server problems before your website goes down. Vetran database server medic Josh Berkus will go through the various steps PostgreSQL Experts normally takes to make sure customer database servers are "healthy".

A regular health check generally includes: * Configuration checkup * Hardware checkup * Resource usage checkup * OS Checkup * Application checkup * Slow query checkup

After we've determined the server is "healthy" we then proceed with monitoring and change control setup to make sure it stays healthy, including: * monitoring the database server * monitoring the OS * configuration change management

This tutorial will include the details, scripts and tools for all of the above checkups. Become a database medic yourself! Make your database servers healthy.