PostgreSQL 14 Administration Cookbook
Over 175 proven recipes for database administrators to manage enterprise databases effectively
Simon Riggs
Gianni Ciolli
BIRMINGHAM—MUMBAI
PostgreSQL 14 Administration Cookbook
Copyright © 2022 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
Publishing Product Manager: Devika Battike
Senior Editor: David Sugarman
Content Development Editor: Joseph Sunil
Technical Editor: Rahul Limbachiya
Copy Editor: Safis Editing
Project Coordinator: Aparna Nair
Proofreader: Safis Editing
Indexer: Tejal Daruwale Soni
Production Designer: Alishon Mendonca
Marketing Coordinator: Priyanka Mhatre
First published: October 2010
Second Edition: April 2015
Third Edition: April 2017
Fourth Edition: May 2018
Fifth Edition: May 2019
Sixth Edition: April 2022
Production reference: 1240222
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.
ISBN 978-1-80324-897-4
Contributors
About the authors
Simon Riggs is a Postgres Fellow at EnterpriseDB (EDB), a member of the company's executive management team, and a major developer of PostgreSQL for over 15 years. At EDB, he contributes to technical strategy and works with key customers directly. Before this, Simon was the founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL over the course of 17 years, initiating new projects, contributing ideas, and committing many important changes. He continues his work with the PostgreSQL community as a developer and on patch review. Simon is also a regular speaker at PostgreSQL conferences. Simon lives happily with his wife Karen in England.
Gianni Ciolli is the Vice President for Solutions Architecture at EnterpriseDB (EDB). As a PostgreSQL consultant, he has driven many successful enterprise deployments for customers in every part of the globe. Gianni is respected worldwide as a popular speaker and trainer at many PostgreSQL conferences in Europe and abroad over the last 14 years. He has worked with free and open source software since the 1990s as an active member of the community (the Prato Linux User Group and the Italian PostgreSQL Users Group). Gianni has a PhD in mathematics from the University of Florence. He lives in London with his son. His other interests include music, drama, poetry, and athletics.
About the reviewers
Marcelo Diaz is a software engineer with more than 15 years of experience, with a special focus on PostgreSQL. He is passionate about open source software and has promoted its application in critical and high-demand environments where he has worked as a software developer and consultant for both private and public companies. He currently works very happily at Cybertec and as a technical reviewer for Packt Publishing. He enjoys spending his leisure time with his daughter, Malvina, and his wife, Romina. He also likes playing football.
Tomas Vondra is a PostgreSQL committer and works as a principal database engineer at EnterpriseDB. He started working with PostgreSQL in 2003, initially as a user and developer of systems on top of PostgreSQL, learning various aspects of operating and tuning the database. Eventually, he started to contribute patches of increasing complexity. After some time, he was recognized as a major contributor and became a committer in 2018. At EnterpriseDB, he helps customers and users with all sorts of issues and focuses on features related to performance, query optimizer capabilities, extended statistics, and reliability. He's also the author of various plugins and extensions. He lives in Prague, Czech Republic.