PostgreSQL 15 Cookbook: 100+ expert solutions across scalability, performance optimization, essential commands, cloud provisioning, backup, and recovery

Practical Recipes for PostgreSQL 15 🐘

PostgreSQL 15 Cookbook is built for people who need to get real work done with PostgreSQL. Instead of long theoretical detours, it presents more than 100 expert solutions across scalability, performance optimization, essential commands, cloud provisioning, backup, and recovery. The recipe format makes it easy to jump straight to a task, compare approaches, and adapt the steps to your own environment.

From Installation to Advanced Administration

The opening chapters cover PostgreSQL 15 architecture, installing from binaries or source code, upgrading minor and major releases, reading start-up logs, and choosing server access methods. They continue into database structural objects, memory configuration, key configuration parameters, schemas, indexing techniques, concurrent indexes, TOAST, temporary tables, SELECT in WITH queries, recursive queries, and common table expressions.

Cloud, Migration, and Recovery ☁️

Cloud-focused recipes show how to create and manage PostgreSQL instances with AWS EC2 and RDS, perform native backup and restore, configure connections, and set up replication, including bi-directional replication with pglogical. Migration coverage includes moving from on-premise systems to AWS, using AWS Data Migration Service, moving from EC2 to RDS, preparing pgloader, migrating from MySQL to PostgreSQL, and setting up foreign data wrappers.

WAL, Vacuum, Partitioning, and High Availability ⚙️

Later chapters tackle archive mode, WAL compression, WAL performance parameters, continuous archiving, remote WAL archive options, vacuum processes, transaction log sizing, and autovacuum debugging. Partitioning and sharding recipes cover declarative partitioning, vertical and horizontal partitioning, attaching and detaching partitions, table inheritance, automatic partitions, partition pruning, Citusdata sharding, and shard repair. High availability material includes master-slave replication, delayed standby, repmgr, PITR recovery, Patroni clusters, HAProxy, PgBouncer, and upgrades on replication clusters.

Security, JSON, and Day-to-Day Queries

The final areas address BLOB imports, shell-script queries, PostgreSQL JSON querying, the CAST operator, database consistency and integrity, roles and membership, SSL authentication, encryption, pgAudit, and audit logs with PostgreSQL triggers. These topics make the book useful well beyond initial setup, especially for administrators who need to keep systems secure, observable, and reliable.

Who Will Get the Most From It

Database administrators, PostgreSQL developers, cloud engineers, data engineers, and system administrators will find the most value here. The book assumes some familiarity with SQL and PostgreSQL concepts, but its recipe structure supports both focused troubleshooting and broader skill building. Keep it nearby for production tasks, migration planning, recovery drills, and performance work. This digital edition is available from Digital Delights.