Iliyan Kostadinov Feb 22, 2024

Feefo Verified review

Federico Pastor Feb 09, 2024

The "PostgreSQL 16 - Administration Cookbook" by various authors, is an essential resource for anyone tasked with the administration of PostgreSQL databases. This book provides a thorough guide covering a wide range of topics from basic maintenance to advanced performance tuning. Its practical approach, with real-world examples and tips, makes complex subjects accessible and applicable for daily tasks.What truly stands out is the detailed coverage of PostgreSQL 16's latest features, making it indispensable for those looking to update their knowledge or manage modern PostgreSQL environments efficiently. Whether you're a seasoned administrator or new to PostgreSQL, this cookbook is a valuable asset, offering clear solutions to enhance your database systems.In summary, this book is a concise, yet comprehensive guide that I highly recommend to PostgreSQL administrators seeking to improve their skills and understanding of the database system.

Amazon Verified review

Darnell Grantham Jr. Jan 10, 2024

PostgreSQL16 Administration Cookbook, written by a collective of computer scientists and database engineers, Gianni Ciolli, Boriss Mejias, Jimmy Angelakos, Vibhor Kumar, and Simon Riggs. This book is a massive collective of material spanning twelve chapters which contain thorough "recipes" or 180+ instructional notes for configuring, administering and maintaining PostgreSQL. When we think of a cookbook, we typically imagine a collection of recipes with a description of the dish, required ingredients, preparation and cook time. The authors in this same vein, provides the database administrator with frequently most used tasks that a PostgreSQL or SQL database administrator performs such as server configuration, managing security and permissions, modifying and altering database table objects, schemas and views, monitoring database performance, setting up replication and many more topics. To get the most out of this book, it is best to download the full client and server packages on your laptop, VM or server. Most of these examples are listed in command line using psql; however, pgAdmin offers a GUI tool as an alternative.If you have any knowledge of TSQL scripting using batch statements, the authors fully explain Atomicity and promote scripting over GUI.If you have experience or some knowledge of SQL monitoring then Chapter 8 presents recommendations of external monitoring tools such as Prometheus, Munin and Grafana in addition to Postgres' own pgAdmin and pgBadger which can monitor log files from the pg_stat_activity table and generate error and exception charts in html. Chapter 12 dives into replication and High Availability(HA). One of the authors, Simon Riggs, is the actual engineer who developed most of the replication features of PostgreSQL and explains it carefully although offering no guarantee that it will be a seamless configuration for all users, all the time. Riggs carefully explains streaming replication (SR) using the physical transaction logs or write-ahead logs (WAL) which if you are familiar with log shipping, writes data to a remote node. Riggs also breaks down cascading relay replication from one master node to multiple nodes where a secondary node can also cascade data to tertiary nodes and beyond. Overall, there is a large amount of material that this book covers and it is best to create a sandbox environment to get the most out of it. This is a must-have resource.

Amazon Verified review

H2N Dec 13, 2023

This cookbook is a nice guide for anyone who is using PostgreSQL database management. This book introduced the latest features of PostgreSQL 16, known for its robust performance. Its practical, recipe-based approach covers everything from basic stuffs such as table creation to security, making it accessible for both new people in the field or experts. Tackling both basic and advanced topics, including role monitoring and cloud deployments, it's a great resource for effective database management.

Amazon Verified review

Matvey Osipov Jan 07, 2024

From backup/restore operations to advanced topics such as replication, not only does this book cover general administration topics like security, monitoring, performance tuning, it covers best practices for database design giving new developers/admins to PostgreSQL a great reference if they are tasked with creating and/or maintaining a PostgreSQL database server.Personally coming from a SQL Server heavy background, this book eases you into how a PostgreSQL database operates and breaks down each component (eg. data files, log files, where everything is on the server PG is on and how to manage it!, etc) that you need to understand how things operation "under the hood" and how it operates in different environments like the cloud if you're not using your own infrastructure.To summarize, this book will break practical/crucial administration tasks you need to know into "How it works" and "How to do it" style demonstrations you can use in the real world. So if you are a new or existing PostgreSQL administrator or looking to learn PostgreSQL database administration, this is the perfect book!

Amazon Verified review

PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices

What do you get with eBook?