PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Tetsuo Sakata
Day Talks - 1 - Thursday - 2012-05-17
Room MRT 212
Start time 13:00
Duration 01:00
ID 434
Event type Workshop
Track DBA
Language used for presentation English

Database Ops

Easy and Effective Operation for production systems with PostgreSQL

NTT (Nippon Telegraph and Telephone) group has made effort to introduce PostgreSQL to its production systems that are large and mission-critical. Introducing PostgreSQL, we found it may be an obstacle that operation tools for PostgreSQL are not provided enough. So we have developed tools for backup, data load, and performance monitoring. In the talk, we will introduce these tools and how to improve database operation using them.

NTT group, which is the largest telecommunication career in Japan providing more than 120 million subscribers, has made effort introducing PostgreSQL to its production systems that support telecommunication.

When we apply PostgreSQL to a production system, we will have to do many 'house-keeping chores'; At the beginning, you will have to load initial data to PostgreSQL, just after starting operation, you will have to periodically take back up files against data loss caused by media crash.

Many proprietary DBMS provide operational and/or management tools to make DBA's work easier and more efficient. Additionally, such a tool provides an easy and standard way of oprerations, it enables not a skilled engineer to manage database systems well.

Concerning PostgreSQL, such tools are not enough provided, it may be an obstacle to introduce PostgreSQL into enterprise systems. So we have developed some operational tools for taking back up, loading data and monitoring performance. And we provide technical know-hows about appropriate operations so that an engineer who is not familiar with PostgreSQL as we expect can manage PostgreSQL well.

The talk will introduce our daily operation activities with assistance of the tools; pgrman for taking backups, pgbulkload for data loading with data cleansing, and pg_statsinfo for performance monitoring. Talking things above we hope to share PostgreSQL operation know-hows with many DBAs.