PostgreSQL Administration Cookbook, 9.5/9.6 Edition

Więcej o książce

Over 90 recipes to help you administer your PostgreSQL database more efficiently. This book provides a comprehensive guide to effectively managing your PostgreSQL 9.6 database. It covers essential capabilities for monitoring, replication, and ensuring high security and availability. Aimed at administrators with a basic understanding of PostgreSQL, it offers step-by-step, recipe-based solutions to common administrative challenges. Readers will learn to implement features that enhance reliability and performance, manage versions 9.5 and 9.6, and access advanced tips for experienced users. The book explores best practices for planning and designing live databases, selecting robust backup and recovery techniques, and provides clear guidance on replication and high availability, including the latest on Logical and Bi-Directional Replication. PostgreSQL serves as an open-source database management tool for large data sets and JSON documents. The content starts with straightforward recipes to help you navigate your database, progressing to core features such as configuration, server control, tables, and data management. It addresses various issues database administrators face, from creating tables and managing views to improving performance and securing databases. Recipes also emphasize high availability, concurrency, replication, backup and recovery, diagnostics, and troubleshooting. With varying difficulty levels, this book cat