Items related to PostgreSQL 11 Administration Cookbook: Over 175 recipes...

PostgreSQL 11 Administration Cookbook: Over 175 recipes for database administrators to manage enterprise databases - Softcover

 
9781789537581: PostgreSQL 11 Administration Cookbook: Over 175 recipes for database administrators to manage enterprise databases

Synopsis

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

Key Features

  • Study and apply the newly introduced features in PostgreSQL 11
  • Tackle any problem in PostgreSQL 11 administration and management
  • Catch up on 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.

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.

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 book is designed for database administrators, data architects, database developers, or anyone with an interest in planning and running live production databases using PostgreSQL 11. It is also ideal if you're looking for hands-on solutions to any problem associated with PostgreSQL 11 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 & Data
  6. Security
  7. Database Administration
  8. Monitoring & Diagnosis
  9. Regular Maintenance
  10. Performance & Concurrency
  11. Backup & Recovery
  12. Replication & Upgrades

"synopsis" may belong to another edition of this title.

About the Author

Simon Riggs is the CTO of 2ndQuadrant, having contributed to PostgreSQL as a major developer and committer for 14 years. He has written and designed features for replication, performance, BI, management, and security. Under his guidance, 2ndQuadrant is now a leading developer of open source PostgreSQL, serving hundreds of clients in USA, Europe, and worldwide. Simon is a frequent speaker at many conferences on PostgreSQL Futures. He has worked as a database architect for 30 years.

Gianni Ciolli is the head of professional services at 2ndQuadrant and has been a PostgreSQL consultant, trainer, and speaker at many PostgreSQL conferences in Europe and abroad over the last 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and open source software since the 1990s and is active in the community (the Prato Linux User Group and the Italian PostgreSQL Users Group). He lives in London with his son. His other interests include music, drama, poetry, and athletics.

Sudheer Kumar Meesala is a lead architect at Endurance International Group and has spent the last few years designing and building scalable and secure web applications within finance and internet industries. A large part of his job has included decomposing monolithic legacy applications into microservices. This has required a deep understanding of PostgreSQL, Cassandra, and other NoSQL databases. Other key areas of interest are container orchestration, DevOps, and more. He is also an accomplished speaker and trainer. He lives in Bangalore, India, and spends far too much time in traffic jams.

"About this title" may belong to another edition of this title.

  • PublisherPackt Publishing
  • Publication date2019
  • ISBN 10 1789537584
  • ISBN 13 9781789537581
  • BindingPaperback
  • LanguageEnglish
  • Number of pages600

Buy Used

Condition: Very Good
May have limited writing in cover...
View this item

FREE shipping within U.S.A.

Destination, rates & speeds

Search results for PostgreSQL 11 Administration Cookbook: Over 175 recipes...

Stock Image

Riggs, Simon; Ciolli, Gianni; Meesala, Sudheer Kumar
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
Used Paperback

Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.4. Seller Inventory # G1789537584I4N00

Contact seller

Buy Used

US$ 11.96
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Riggs, Simon; Ciolli, Gianni; Meesala, Sudheer Kumar
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
Used Paperback

Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. No Jacket. Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.4. Seller Inventory # G1789537584I4N10

Contact seller

Buy Used

US$ 11.96
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Riggs, Simon
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
Used Softcover

Seller: medimops, Berlin, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: very good. Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Seller Inventory # M01789537584-V

Contact seller

Buy Used

US$ 15.12
Convert currency
Shipping: US$ 10.18
From Germany to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Riggs, Simon, Meesala, Sudheer Kumar, Ciolli, Gianni
Published by Packt Publishing, Limited, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
Used Softcover

Seller: Better World Books Ltd, Dunfermline, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Very Good. Ships from the UK. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # 52009639-20

Contact seller

Buy Used

US$ 15.36
Convert currency
Shipping: US$ 10.63
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Simon Riggs
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
New Paperback

Seller: Grumpys Fine Books, Tijeras, NM, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: new. Prompt service guaranteed. Seller Inventory # Clean1789537584

Contact seller

Buy New

US$ 28.91
Convert currency
Shipping: US$ 4.25
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Simon Riggs; Gianni Ciolli; Sudheer Kumar Meesala
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
New paperback

Seller: Textbooks_Source, Columbia, MO, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

paperback. Condition: New. Ships in a BOX from Central Missouri! UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes). Seller Inventory # 009244495N

Contact seller

Buy New

US$ 33.72
Convert currency
Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

Quantity: 12 available

Add to basket

Seller Image

Simon Riggs; Gianni Ciolli; Sudheer Kumar Meesala
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
Used Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 35767517

Contact seller

Buy Used

US$ 45.68
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: 6 available

Add to basket

Seller Image

Simon Riggs; Gianni Ciolli; Sudheer Kumar Meesala
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
New Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 35767517-n

Contact seller

Buy New

US$ 51.07
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: 6 available

Add to basket

Seller Image

Riggs, Simon
Published by Packt Publishing 5/6/2019, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
New Paperback or Softback

Seller: BargainBookStores, Grand Rapids, MI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback or Softback. Condition: New. PostgreSQL 11 Administration Cookbook 2.24. Book. Seller Inventory # BBS-9781789537581

Contact seller

Buy New

US$ 53.72
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 5 available

Add to basket

Stock Image

Simon Riggs
Published by Packt Publishing, 2019
ISBN 10: 1789537584 ISBN 13: 9781789537581
New PAP
Print on Demand

Seller: PBShop.store US, Wood Dale, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781789537581

Contact seller

Buy New

US$ 64.10
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

There are 13 more copies of this book

View all search results for this book