PostgreSQL Administration Cookbook

Over 90 recipes to help you administer your PostgreSQL database more efficiently About This Book * Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently, * Monitor, replicate and make your database highly secure and available, * A step-by-step, recipe-base [...]
Visa längre beskrivning

Over 90 recipes to help you administer your PostgreSQL database more efficiently About This Book * Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently, * Monitor, replicate and make your database highly secure and available, * A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with ease Who This Book Is For If you are an administrator who wants to leverage the useful PostgreSQL functionalities to create and manage databases efficiently, this is the book for you. This book assumes a basic working knowledge of PostgreSQL, and some previous experience in PostgreSQL administration is required. What you will learn * Implement PostgreSQL features for reliability and performance * Harness the power of the latest PostgreSQL 9.5 & 9.6 features * Manage PostgreSQL versions 9.5 & 9.6* Advanced technical tips for experienced users * Explore best practices for planning and designing live databases * Select and implement robust backup and recovery techniques * Concise and clear guidance on replication and high availability * Latest details on Logical Replication and Bi-Directional Replication In Detail PostgreSQL is an open-source database management tool used for handling large data sets (big data) and also as a JSON document database. Starting with short and simple recipes to get you back up and running with an exploration of the ins and outs of your database, you will soon dive into core features such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters - spanning from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics like high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance.By the end of this book, you will have all the knowledge you need to run, manage and maintain your PostgreSQL efficiently. DBAs of all levels will be catered for with recipes of varying difficulty, allowing the reader to administer PostgreSQL efficiently. Tagline: Over XXX recipes to help you administer your PostgreSQL database more efficiently