Explore concise and clear guidance on replication and high availability

Discover advanced technical tips for experienced users

About

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 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.

Throughout this book, you will be introduced to these new features such as logical replication, native table partitioning, additional query parallelism, and much more. You will learn how to tackle a variety of problems that are basically the pain points for any database administrator - from creating tables to managing views, from improving performance to securing your database. More importantly, the book pays special attention to topics such as monitoring roles, backup, and recovery of your PostgreSQL 10 database, ensuring high availability, concurrency, and replication.

By the end of this book, you will know everything you need to know to be the go-to PostgreSQL expert in your organization.

Features

Get to grips with the capabilities of PostgreSQL 10 to administer your database more efficiently

Authors

Simon Riggs

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

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.

Get now with a Subscription

FREE

Renews at $9.99pm

Plus unlimited access to Packt's 7,500+ eBooks and Videos

Buy

eBook

$39.99

Buy

Print + eBook

$49.99

Qty

What do I get with a Packt subscription?

Exclusive monthly discount - no contract

Unlimited access to entire Packt library of over 7,500+ eBooks and Videos

100 new titles added every month on new and emerging tech

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

When you visit any website, it may store or retrieve information on your browser,usually in the form of cookies. This information does not usually identify you, but it does help companies to learn how their users are interacting with the site.

We respect your right to privacy, so you can choose not to accept some of these cookies. Choose from the different category headers to find out more and change your default settings.

Please note if you have arrived at our site via a cashback website, turning off targeting or performance cookies will mean we cannot verify your transaction with the referrer and you may not receive your cashback.

Strictly Necessary Cookies
Always active

These cookies are essential for the website to function and they cannot be turned off. They are usually only set in response to actions made by you on our site, such as logging in, adding items to your cart or filling in forms. If you browse our website, you accept these cookies.

Cookies are used by

Packt Publishing

Google Analytics

Heap

Performance Cookies

These cookies allow us to keep track of how many people have visited our website, how they discovered us, and how they interact with the site.All the information used is aggregated, and completely anonymous. If you do not allow these cookies we won’t know you have visited us.

Cookies are used by

Facebook Pixel

Google Adwords

Targeting Cookies

These cookies are placed on our site by our trusted third-party providers.They help us to personalise our adverts and provide services to our customers such as live chat.

If you have arrived at our site via a cashback website, turning off Targeting Cookies will mean we cannot verify your transaction with the referrer and you may not receive your cashback.