PostgreSQL 10 Administration Cookbook - Fourth Edition

A Practical Guide to administer, monitor & replicate your Postgre SQL 10 Database. About This Book * Get to grips with the capabilities of PostgreSQL 10 to administer your database more efficiently * Monitor, tune, secure and protect your database for optimal performance * A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL 10 administration with ease Who This Book Is For This book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience. What You Will Learn * Bcome efficient with implementing new PostgreSQL features to improve performance and reliability. * Configure PostgreSQL 10 by working with parameters to administer it effectively. * Manage open source PostgreSQL versions 10 on various platforms. * Discover advanced technical tips for experienced users. * Explore best practices for planning and designing live databases. * Select and implement robust backup and recovery techniques. * Explore concise and clear guidance on replication and high availability. In Detail PostgreSQL is the powerful, open source database management system; now recognized as the expert's choice for a large scale range of applications. It has an enviable reputation for performance and stability. With some new features in its arsenal, the new version allows users to scale up their PostgreSQL infrastructure, such as, Logical Replication which is a built-in option for replicating specific tables, Native Table Partitioning, Additional Query Parallelism which includes index scans, bitmap scans and much more. PostgreSQL 10 Administration Cookbook is your go-to book to take your learnings to a new level. It takes a step-by-step, recipe-based approach, where each recipe focuses on a particular challenge faced by a PostgreSQL administrator. The book will begin with simple recipes to help you troubleshoot failed connection and updating the parameter file, and so on. You will then be introduced to core features, such as configuration, server control, tables, and data. Readers will learn how to tackle a variety of problems a which are basically the pain area for the database administrator, from creating tables to managing views, from improving performance to securing your database. More importantly, the book pays special attention to topics such as Monitoring roles, backup, and recovery of your PostgreSQL 10 database, ensuring high availability, concurrency, and replication. By the end of this book, you will know everything you need to be effective and efficient as a PostgreSQL administrator.