---
product_id: 602280467
title: "PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices"
brand: "gianni ciolliboriss mejíasjimmy angelakosvibhor kumarsimon riggs"
price: "A$90"
currency: AUD
in_stock: true
reviews_count: 5
url: https://www.desertcart.com.au/products/602280467-postgresql-16-administration-cookbook-solve-real-world-database-administration-challenges
store_origin: AU
region: Australia
---

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

**Brand:** gianni ciolliboriss mejíasjimmy angelakosvibhor kumarsimon riggs
**Price:** A$90
**Availability:** ✅ In Stock

## Quick Answers

- **What is this?** PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices by gianni ciolliboriss mejíasjimmy angelakosvibhor kumarsimon riggs
- **How much does it cost?** A$90 with free shipping
- **Is it available?** Yes, in stock and ready to ship
- **Where can I buy it?** [www.desertcart.com.au](https://www.desertcart.com.au/products/602280467-postgresql-16-administration-cookbook-solve-real-world-database-administration-challenges)

## Best For

- gianni ciolliboriss mejíasjimmy angelakosvibhor kumarsimon riggs enthusiasts

## Why This Product

- Trusted gianni ciolliboriss mejíasjimmy angelakosvibhor kumarsimon riggs brand quality
- Free international shipping included
- Worldwide delivery with tracking
- 15-day hassle-free returns

## Description

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

## Images

![PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices - Image 1](https://m.media-amazon.com/images/I/61oTDTLV9mL.jpg)

## Customer Reviews

### ⭐⭐⭐⭐⭐ Good lecture.
*by R***. on November 9, 2024*

This book adopts the recipe format: it states a problem, provides one or more solutions, and explains them. This format is useful for finding solutions quickly. The content is of high quality. Some prior experience with databases is required to get the most out of this book.

### ⭐⭐⭐⭐⭐ A Better Understanding of Database Administration
*by D***. on January 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.

### ⭐⭐⭐⭐ Preferred PostgreSQL DBA Handbook
*by V***I on February 8, 2024*

Though the title of book is specific to PostgreSQL Administration Cookbook, there are certain topics like 'Security', 'Database Administration', 'Monitoring and Diagnosis', 'Performance and Concurrency' covered best practices which can be learnt and applied in any given database. As authors described this book is very much database administrator centric. Authors clearly outlined topics in a recipe style pattern (Getting Ready, How to do it, How it works) which is good approach in engaging readers and 'try-out' right away.I consider this book as a sequel to Learn PostgreSQL book (by authors - Luca Ferrari, Enrico Pirozzi) for the individuals who want to be a well rounded data engineers.Once again very much thankful to <packt> publishers for giving me such an opportunity to review both PostgreSQL book.

## Frequently Bought Together

- PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices
- Learn PostgreSQL: Use, manage, and build secure and scalable databases with PostgreSQL 16
- PostgreSQL DBA (v16, v15, v14, v13, v12): (GitHub link provided) Full PostgreSQL Database Administrator's Guide, Secret DBA skills, High Availablity, ... Special OLTP & OLAP Tuning, Advanced Skills

---

## Why Shop on Desertcart?

- 🛒 **Trusted by 1.3+ Million Shoppers** — Serving international shoppers since 2016
- 🌍 **Shop Globally** — Access 737+ million products across 21 categories
- 💰 **No Hidden Fees** — All customs, duties, and taxes included in the price
- 🔄 **15-Day Free Returns** — Hassle-free returns (30 days for PRO members)
- 🔒 **Secure Payments** — Trusted payment options with buyer protection
- ⭐ **TrustPilot Rated 4.5/5** — Based on 8,000+ happy customer reviews

**Shop now:** [https://www.desertcart.com.au/products/602280467-postgresql-16-administration-cookbook-solve-real-world-database-administration-challenges](https://www.desertcart.com.au/products/602280467-postgresql-16-administration-cookbook-solve-real-world-database-administration-challenges)

---

*Product available on Desertcart Australia*
*Store origin: AU*
*Last updated: 2026-03-22*