Ebook PostgreSQL 16 Administration [Code- 9735E]

1. Main features:

✓ Enhance your skills as a database administrator by improving query performance, managing  backup and recovery, setting up replication, and more.

✓ Grasp the essential knowledge of database management with a recipe-based approach using the latest PostgreSQL 16 features.

✓ New and updated recipes on important PostgreSQL topics like Monitoring, Logging, Scalability, etc.

2. Book description:

PostgreSQL has seen a huge increase in its customer base over the past few years and is becoming one of the go-to solutions for anyone with a specific database challenge. This PostgreSQL book covers all the foundations of Database Administration in a problem-solution format. It is intended to be the perfect desk reference guide.

This new version focuses on recipes based on the new PostgreSQL 16 release. Additions include handling complex batch loading scenarios with SQL MERGE statements, security enhancements, running Postgres on Kubernetes or with TPA and Ansible, and more. This release also focuses on certain performance increases, such as optimizing queries and speeding up specific operations, such as sorting. It will help you understand the role, ensuring high availability, concurrency, and replication. It also draws your attention to aspects such as validating backups, recovery, monitoring, and scaling. This book will act as a comprehensive solution to all your real-world database administration challenges.

3. What you will learn:

✓ Discover how to improve batch data loading with the SQL MERGE statement.

✓ Use logical replication to apply large transactions in parallel.

✓ Improve your backup and recovery performance with server-side compression.

✓ Solve basic to advanced and real-world PostgreSQL challenges with practical recipes.

✓ Monitor and fine-tune your database with ease.

✓ Learn how to navigate the newly introduced features of PostgreSQL 16.

✓ Effectively secure your PostgreSQL database with new and updated features.

4. Who is this book for:

This Postgres book is for database administrators, data architects, database developers, and anyone interested in planning and running live production databases with PostgreSQL 16. People who are looking for practical solutions to all related problems. Those interested in administering PostgreSQL 16 will also find this book useful. Some experience dealing with PostgreSQL databases will help you get the most out of this book, but it’s a useful resource even if you’re just starting your Postgres journey.

5. Table of contents:

✓ Chapter 01: The first steps.

✓ Chapter 02: Exploring Database.

✓ Chapter 03: Server Configuration.

✓ Chapter 04: Server Control.

✓ Chapter 05: Tables and Data.

✓ Chapter 06: Security.

✓ Chapter 07: Database Administration.

✓ Chapter 08: Monitoring and Diagnosis.

✓ Chapter 09: Regular Maintenance.

✓ Chapter 10: Performance and Concurrency.

✓ Chapter 11: Backup and Recovery.

✓ Chapter 12: Replication and Upgrade.