PostgreSQL 11 Administration Cookbook

A practical guide to administer, monitor and replicate your PostgreSQL 11 database
Code Files

PostgreSQL 11 Administration Cookbook

Simon Riggs, Gianni Ciolli, Sudheer Kumar Meesala
New Release!

A practical guide to administer, monitor and replicate your PostgreSQL 11 database
Packt Subscription
FREE
$9.99/m after trial
eBook
$14.40
RRP $35.99
Save 59%
Print + eBook
$44.99
RRP $44.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$14.40
$44.99
$9.99 p/m after trial
RRP $35.99
RRP $44.99
Subscription
eBook
Print + eBook
Start a FREE 10-day trial

Frequently bought together


PostgreSQL 11 Administration Cookbook Book Cover
PostgreSQL 11 Administration Cookbook
$ 35.99
$ 14.40
Learning PostgreSQL 11 - Third Edition Book Cover
Learning PostgreSQL 11 - Third Edition
$ 31.99
$ 12.80
Buy 2 for $27.20
Save $40.78
Add to Cart

Book Details

ISBN 139781789537581
Paperback600 pages

Book Description

PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 11 allows you to scale up your PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.

The book will introduce you to new features such as logical replication, native table partitioning, additional query parallelism, and much more to help you to understand and control, crash recovery and plan backups. You will learn how to tackle a variety of problems and pain points for any database administrator such as creating tables, managing views, improving performance, and securing your database. As you make steady progress, the book will draw attention to important topics such as monitoring roles, backup, and recovery of your PostgreSQL 11 database to help you understand roles and produce a summary of log files, ensuring high availability, concurrency, and replication.

By the end of this book, you will have the necessary knowledge to manage your PostgreSQL 11 database efficiently.

Table of Contents

What You Will Learn

  • Troubleshoot open source PostgreSQL version 11 on various platforms
  • Deploy best practices for planning and designing live databases
  • Select and implement robust backup and recovery techniques in PostgreSQL 11
  • Use pgAdmin or OmniDB to perform database administrator (DBA) tasks
  • Adopt efficient replication and high availability techniques in PostgreSQL
  • Improve the performance of your PostgreSQL solution

Authors

Table of Contents

Book Details

ISBN 139781789537581
Paperback600 pages
Read More

Read More Reviews

Recommended for You

Learning PostgreSQL 11 - Third Edition Book Cover
Learning PostgreSQL 11 - Third Edition
$ 31.99
$ 12.80
PostgreSQL 10 Administration Cookbook Book Cover
PostgreSQL 10 Administration Cookbook
$ 39.99
$ 16.00
PostgreSQL 11 in 7 days [Video] Book Cover
PostgreSQL 11 in 7 days [Video]
$ 124.99
$ 50.00
PostgreSQL 11 Server Side Programming Quick Start Guide Book Cover
PostgreSQL 11 Server Side Programming Quick Start Guide
$ 31.99
$ 12.80
Mastering PostgreSQL 11 - Second Edition Book Cover
Mastering PostgreSQL 11 - Second Edition
$ 31.99
$ 12.80
Active Directory Administration Cookbook Book Cover
Active Directory Administration Cookbook
$ 35.99
$ 14.40