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

Simon Riggs, Gianni Ciolli, Boriss Mejías, Jimmy Angelakos, Vibhor Kumar

Summary

PostgreSQL has seen a huge increase in its customer base in the past few years and is becoming one of the go-to solutions for anyone who has a database-specific challenge. This PostgreSQL book touches on all the fundamentals of Database Administration in a problem-solution format. It is intended to be the perfect desk reference guide.This new edition focuses on recipes based on the new PostgreSQL 16 release. The additions include handling complex batch loading scenarios with the SQL MERGE statement, security improvements, running Postgres on Kubernetes or with TPA and Ansible, and more. This edition also focuses on certain performance gains, such as query optimization, and the acceleration of specific operations, such as sort. It will help you understand roles, ensuring high availability, concurrency, and replication. It also draws your attention to aspects like validating backups, recovery, monitoring, and scaling aspects. This book will act as a one-stop solution to all your real-world database administration challenges.By the end of this book, you will be able to manage, monitor, and replicate your PostgreSQL 16 database for efficient administration and maintenance with the best practices from experts.

Available since: 12/04/2023.

Print length: 636 pages.

Science & Technology

Other books that might interest you

Navigating the Complexities of...

MD FAAN Louis R. Caplan

Navigating the Complexities of Stroke provides a practical guide for the lay public and medical professionals. Dr. Louis R. Caplan, one of the world's leading experts, guides listeners through the subject in a straightforward and accessible manner. He turns to the mechanics of the stroke itself, discussing the complexities of the two major kinds and the resulting damage. Caplan offers information and advice that listeners will find useful: the medical conditions and other factors that create risk, stroke symptoms, abnormalities that doctors look for, tests available to evaluate strokes, complications and disabilities that can result, and the paths of treatment and rehabilitation. He offers real-life cases of victims and their families that demonstrate successful recovery, but also reveal the sometimes troubling impact of strokes on survivors and their families, who can suffer frustration and demoralization that the medical profession often overlooks in its biological focus. Caplan also examines strokes in children and young adults, who are often neglected in literature that is largely aimed at seniors. 
 
 
 
Navigating the Complexities of Stroke empowers victims, families, and general medical providers. It puts in listeners' hands the knowledge necessary to avoid strokes, address them quickly, and recover, so they won't lose heart when it is needed most.

Show book

The Life of Birds

David Attenborough

A fully updated new edition of David Attenborough’s bestselling classic.
BIRDS. 11,000 species, the most widespread of all animals: on icebergs, in the Sahara or under the sea, at home in our gardens or flying for over a year at a time. Earthbound, we can only look and listen, enjoying their lightness, freedom and richness of plumage and song.
David Attenborough has been watching and learning all his life. His classic book, now fully updated with the latest discoveries in ornithology, is a brilliant introduction to bird behaviours around the world: what they do and why they do it. He looks at each step in birds' lives and the problems they have to solve: learning to fly; finding food; communicating; mating and caring for nests, eggs and young; migrating; facing dangers and surviving harsh conditions.
Sir David has no equal in helping others to learn and making it exciting. His curiosity and enjoyment are infectious. He shows the lifelong pleasure that birds around us offer, and how much we miss if unaware of them.
Attenborough, the Sunday Times bestselling author, delves into the science of birdwatching, offering readers a comprehensive guide to understanding the natural world. His passion for zoology and ecology is palpable, making this non-fiction book a captivating read for anyone interested in nature and its history.
For fans of David Allen Sibley (Birds of Instagram), Joshua Foer (Atlas Obscura, 2nd Edition), Steve Brusatte (The Rise and Reign of the Mammals), Martin Stevens (Sensory Ecology, Behaviour, and Evolution), and Jonnie Hughes (Earthshot).
HarperCollins 2024

Show book

Deep Listening to Nature

Andrew Skeoch

Deep Listening to Nature is an invitation to open our ears to the natural world.  
 
Beginning by tuning in to the sounds of creatures around us, Andrew discusses how to identify species by call, interpret their communications and find empathy for their sentience.  
 
Listening more broadly, on an ecosystem level, Andrew then asks the question: What does listening reveal about how living systems function, and why do birds in particular negotiate their interactions in such lyrical and extraordinary ways?  
 
From this he suggests we not only listen to learn about nature but learn from nature.  
 
In our current crises – both social and environmental – he asks how we may mimic what the biosphere has achieved in sustaining life as we move toward an ecological future, and in doing so, form a deeper cultural and personal connection to Country.  
 
Andrew encourages us to be still and listen. Extend our senses. Let nature get to know us and in its own way, to welcome us.

Show book

Hearing Happiness - Deafness...

Jaipreet Virdi

Weaving together lyrical history and personal memoir, Virdi powerfully examines society’s—and her own—perception of life as a deaf person in America.

At the age of four, Jaipreet Virdi’s world went silent. A severe case of meningitis left her alive but deaf, suddenly treated differently by everyone. Her deafness downplayed by society and doctors, she struggled to “pass” as hearing for most of her life. Countless cures, treatments, and technologies led to dead ends. Never quite deaf enough for the Deaf community or quite hearing enough for the “normal” majority, Virdi was stuck in aural limbo for years. It wasn’t until her thirties, exasperated by problems with new digital hearing aids, that she began to actively assert her deafness and reexamine society’s—and her own—perception of life as a deaf person in America.
Through lyrical history and personal memoir, Hearing Happiness raises pivotal questions about deafness in American society and the endless quest for a cure. Taking us from the 1860s up to the present, Virdi combs archives and museums in order to understand the long history of curious cures: ear trumpets, violet ray apparatuses, vibrating massagers, electrotherapy machines, airplane diving, bloodletting, skull hammering, and many more. Hundreds of procedures and products have promised grand miracles but always failed to deliver a universal cure—a harmful legacy that is still present in contemporary biomedicine.

Weaving Virdi’s own experiences together with her exploration into the fascinating history of deafness cures, Hearing Happiness is a powerful story that America needs to hear.

Show book

BIOLOGY WORTH LISTENING TO - A...

Darrell Ason

HAVE YOU EVER LOOKED AT THE WORLD AROUND YOU AND WONDERED HOW—life emerged, how species evolved, how ecosystems thrive, and how, against all odds, we humans came to dominate the planet?
If you’ve ever felt that burning curiosity but found traditional science books too dense or intimidating, this guide is for you.
Biology Worth Listening To isn’t a dry lecture—it’s an immersive journey into the story of life itself. Designed for the self-taught scientist, the endlessly curious, and anyone eager to fall back in love with science, this audiobook makes biology accessible, thrilling, and deeply human. Perfect for people with auditory memory who lack time. You’ll discover:The Formation of Life - How we passed from inanimated to animated living beings in that great primordial cauldron that was our planet Earth.The power of evolution—how life constantly reinvents itself in the ultimate survival game.The eternal dance of competition and cooperationThe delicate balance of biodiversityThe impact of human actions on the environment—from colonial times to the present—exploring the consequences of introducing non-native species into new ecosystems.And much more.
AND THE BEST PART? No charts, no complicated formulas, no dry academic talk—just engaging storytelling designed to make you feel the wonder of life. Whether you’re listening on your commute, during a walk, or while relaxing at home, this audiobook is here to reignite your curiosity and remind you why biology is the most fascinating science of all.
SO PRESS PLAY, open your mind and let’s embark on this extraordinary journey together. Because the story of life is really worth listening to.

Show book

AI Ethics and Governance for...

Aria Westwood

This audiobook is narrated by an AI Voice. In *AI Ethics and Governance for Beginners*, you'll find a clear, accessible introduction to the key issues surrounding artificial intelligence today. This book covers essential topics such as how AI systems work, potential risks and biases, and their societal impacts. You'll learn about responsible data management, accountability, and the importance of human-centered approaches. Designed for new learners, it provides practical insights for anyone interested in understanding and engaging with AI’s ethical challenges. By the end, you'll have a solid foundation to think critically about the responsible development and use of AI. 
 
Benefits: 
- Understand the fundamental principles of AI ethics and governance. 
- Recognize common risks, biases, and societal consequences of AI systems. 
- Learn about responsible data practices, privacy, and consent. 
- Gain insights into how organizations can implement accountable AI strategies. 
- Develop a confident, informed perspective on the future impact of AI in society. 
 
Tagline:   
Building a mindful approach to AI’s responsible future.

Show book