CB-India Bonus: Surprise for Frequent Buyers, add books to the cart now!!  
SAP Press, Shroff Publishing and books worth Rs.2000 & above, no shipping charges!!  
Now Pay on Delivery also Available!!
Kindly Note due to the on-going Pandemic Crisis, there can be unexpected delays in 
delivering/procurement of books, we will try our best to supply the books in the 
time frame mentioned but there can be delays beyond our control. 
Please bear with us.

0 Your Cart

PostgreSQL 11 Administration Cookbook:

Over 175 recipes for database administrators to manage enterprise databases

Author: Simon Riggs

Simon Riggs (Author)
Visit Cb-India's Author Page
Books by him and info about author and more.

Are you a Author?
Learn more here

Save
81%

Hover over an image to enlarge

MRP: MRP: $40.35
Net Price: $7.80
You save: $32.55 (80.67%)
Leadtime to ship in days (default): E-Book Immediate, Print Book usually ships in 7-8 days

This product is electronically distributed.

9781789537581
Price in points: 599 points
Reward points: 6 points

Minimum quantity for "PostgreSQL 11 Administration Cookbook:

Over 175 recipes for database administrators to manage enterprise databases

" is 1.

Please sign in to buy

This product cannot be added to the
cart because you are not logged in.

Add to wish list Compare

Share

Description

A practical guide to administering, monitoring and replicating your PostgreSQL 11 database

Key Features

  • Learn and apply the newly introduced features in PostgreSQL 11
  • Tackle any problem in PostgreSQL 11 administration and management
  • Discover expert techniques for monitoring, fine-tuning, and securing your database

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.

Firstly, you'll understand how to control crash recovery and plan backups by working through new features such as logical replication, native table partitioning, and additional query parallelism. You will also learn how to tackle a variety of problems and pain points that database administrators often face including 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. This will help you to gain insights into roles and produce a summary of log files, which will in turn ensure high availability, concurrency, and replication.

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

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

Who this book is for

This intermediate-level book is ideal for database administrators, data architects, database developers, or anyone with an interest in planning and running live production databases using PostgreSQL 11. The book will also prove useful if you're looking for hands-on solutions to problems associated with PostgreSQL11 administration. Some experience with handling PostgreSQL databases will be beneficial.

Table of Contents

  1. First Steps
  2. Exploring the Database
  3. Configuration
  4. Server Control
  5. Tables and Data
  6. Security
  7. Database Administration
  8. Monitoring and Diagnosis
  9. Regular Maintenance
  10. Performance and Concurrency
  11. Backup and Recovery
  12. Replication and Upgrades

Features

Author:
Simon Riggs
Binding:
E-Book
Country Origin:
UK
Edition :
1
Leadtime to ship in days (default):
E-Book Immediate, Print Book usually ships in 7-8 days
Page:
600
Publisher:
Packt Publishing (E-Books)
Year:
2019

Tags

Reviews

No posts found

Possibly you may be interested
 
Fast and high quality delivery

Our company makes delivery all over the country

Quality assurance and service

We offer only those goods, in which quality we are sure