Название: PostgreSQL 18 Cookbook, Third Edition: Upgrade to PostgreSQL 18 with ready troubleshooting across replication, partitioning, security, cloud provisioning, backup, and migration
Автор: Peter G
Издательство: GitforGits
Год: 2026
Страниц: 220
Язык: английский
Формат: pdf, epub (true)
Размер: 13.4 MB

This thoroughly revised 3rd edition troubleshoots through real failure modes, diagnostic techniques, and remediation patterns drawn from years of operating PostgreSQL at scale. In this cookbook, you install PostgreSQL 18, create and design schemas, configure clusters to automatically switch over in case something goes wrong, keep your connections secure using OAuth 2.0, and perform PITR to get your data back exactly how you left it. All the recipes work with a single growing sample database, so each one is clearly connected to the next one, just like how production systems actually develop.

You'll find concrete, tested solutions for things like troubleshooting replication lag, recovering corrupted tables, debugging autovacuum bottlenecks, or migrating away from MD5 authentication. And you'll have the operational confidence to apply them under pressure.

This book is for anyone who wants to feel more confident. Not the swagger of the confident salesperson, but the kind of quiet confidence that comes from having seen a problem before, having figured out its symptoms and applying a fix you understood every step of the way. PostgreSQL 18 has some pretty amazing new features. Basically, asynchronous I/O changes how the server reads from disk. You can use virtual generated columns to model data in ways that just weren't possible before. It's been a long time coming, but we've finally got temporal constraints, OAuth authentication, logical replication slot synchronization, and time-ordered UUIDs, which are all great news for the community. To use them well, we need more than feature lists. We need the instinct to know when to reach for which tool and why.

That's exactly the kind of book I've been trying to write. So, over eleven chapters, we put together a single sample application, and we watch it grow from a simple table used by one employee into a more complex system that's divided into different parts, has backups, is secure using OAuth, and is audited. Each recipe is its own thing, but the chapters build on each other. The vacuum tuning we cover in Chapter 5 is used to inform the partitioning strategy in Chapter 6. The audit triggers of Chapter 9 feed the time-ordered event log we built in Chapter 8. The replication cluster of Chapter 7 is the same one we recover in Chapter 11. By the time you get to the last page, you'll have gone through all the stages of a real PostgreSQL deployment twice if you follow along on your own machine, and once more in the back of your mind every time something breaks at work.

Key Learnings:

Install, configure, and tune PostgreSQL 18 across binary and source code paths
Diagnose startup failures, replication lag, and autovacuum bottlenecks using built-in views
Apply new asynchronous I/O subsystem to accelerate scans and vacuum
Design temporal constraints and virtual generated columns for modern data models
Configure logical replication slot sync for transparent publisher failover
Implement OAuth 2.0 authentication and migrate away from deprecated MD5 passwords
Execute ‘pg_upgrade’ with statistics preservation and parallel compatibility checks
Build partitioned, sharded schemas using declarative partitioning and Citus
Perform point-in-time recovery and selective table or schema restoration confidently

Contents:

Ссылки удалены по требованию правообладателя

ОТСУТСТВУЕТ ССЫЛКА/ НЕ РАБОЧАЯ ССЫЛКА ЕСТЬ РЕШЕНИЕ, ПИШЕМ СЮДА!