PostgreSQL Administration Cookbook - Third Edition by Simon Riggs

PostgreSQL Administration Cookbook - Third Edition

bySimon Riggs, Gianni Ciolli, Hannu Krosing...

Kobo ebook | June 9, 2017

Pricing and Purchase Info

$51.19 online 
$63.94 list price save 19%

Prices and offers may vary in store

Available for download

Not available in stores

about

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

Title:PostgreSQL Administration Cookbook - Third EditionFormat:Kobo ebookPublished:June 9, 2017Publisher:Packt PublishingLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:178588980X

ISBN - 13:9781785889806

Look for similar items by category:

Reviews