PostgreSQL Administration Essentials
- Length: 142 pages
- Edition: 1
- Language: English
- Publisher: Packt Publishing
- Publication Date: 2014-10-16
- ISBN-10: 1783988983
- ISBN-13: 9781783988983
- Sales Rank: #2010813 (See Top 100 Books)
Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases
About This Book
- Learn how to detect bottlenecks and make sure your database systems offer superior performance to your end users
- Replicate your databases to achieve full redundancy and create backups quickly and easily
- Optimize PostgreSQL configuration parameters and turn your database server into a high-performance machine capable of fulfilling your needs
Who This Book Is For
If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators.
In Detail
With more than a quarter of a century of development and innovation, PostgreSQL has gained a reputation for stability, robustness, and ease of use. The variety of features available within PostgreSQL makes it a powerful tool for your professional relational database infrastructure.
With the database administrator in mind, this compact, easy-to-read, and practically-oriented book will make your daily handling of PostgreSQL more efficient and rewarding. You will learn about optimization, bottleneck detection, backup and recovery, replication, logfile management, indexing, and much more in a systematic and carefully structured manner. This invaluable guide will enable you to develop the fundamental skills required to deploy PostgreSQL in order to efficiently manage your databases.
Table of Contents
Chapter 1. Installing PostgreSQL
Chapter 2. Indexing and Performance Tuning
Chapter 3. Users and Permissions
Chapter 4. Managing Logfiles
Chapter 5. Backup and Recovery
Chapter 6. Handling Replication and Improving Performance
Chapter 7. Monitoring PostgreSQL