PostgreSQL Administration Guides by Hans-Jürgen Schönig

Hans-Jürgen Schönig, CEO of CYBERTEC PostgreSQL International GmbH and a PostgreSQL practitioner with more than 25 years of experience, has authored a series of books covering advanced database management. The latest editions focus on PostgreSQL 17 and PostgreSQL 15, with practical guidance drawn from real-world customer support across global deployments.

MasteringPostgreSQL15

Mastering PostgreSQL 17

The sixth edition of this guide begins with the new capabilities introduced in PostgreSQL 17 and moves into the areas that matter most for professional database administration: performance tuning, replication, indexing, and security. The content is built around real-world scenarios, covering how to handle complex queries, optimize execution plans, and work with advanced SQL features such as window functions and JSON support.

Practical approaches are provided for managing database locks, transactions, and stored procedures to maintain peak performance. The book also addresses replication techniques for high availability and troubleshooting methods for identifying and resolving bottlenecks. Completion of the book should leave readers prepared to deploy, secure, and maintain PostgreSQL databases in production environments.

What you will learn:

  • Deploy and manage PostgreSQL in production environments
  • Improve database throughput and ensure speedy responses from PostgreSQL
  • Utilize indexes, partitions, and full-text search
  • Handle transactions, locking, and concurrency issues
  • Secure PostgreSQL with encryption and access controls
  • Implement replication for high availability
  • Get to grips with handling redundancy and data safety
  • Fix common issues and real-world problems faced by PostgreSQL users

Who this book is for: Database administrators, PostgreSQL developers, and IT professionals aiming to implement advanced functionality and handle complex administrative tasks with PostgreSQL 17. A foundational understanding of PostgreSQL, core database concepts, and SQL is expected, with prior administrative experience recommended for getting the most out of the advanced techniques covered.

Mastering PostgreSQL 15

The fifth edition of this book starts by introducing the newly released features of PostgreSQL 15, then moves into building dynamic database solutions for enterprise applications, including both the physical and technical aspects of system design. The material covers logical replication, database clusters, advanced indexing, and user management for maintaining databases, as well as working with the PostgreSQL optimizer to configure the server for high-speed operation.

Additional skills covered include handling transactions, recursion, and JSON/JSONB data, setting up a Patroni cluster, improving query performance, managing network security, and working with backups and replication. The book also discusses PostgreSQL extensions that optimize large database performance and covers migration from Oracle to PostgreSQL.

What you will learn:

  • Use indexing features in PostgreSQL to fine-tune query performance
  • Work with stored procedures and manage backup and recovery
  • Get the hang of replication and failover techniques
  • Improve server security and handle encryption effectively
  • Troubleshoot your PostgreSQL instance for common and uncommon problems
  • Perform database migration from Oracle to PostgreSQL

Who this book is for: PostgreSQL developers, database administrators, and professionals tackling advanced administrative tasks with PostgreSQL 15. Prior experience with PostgreSQL and fundamentals of database administration will help with the concepts covered.

Earlier Titles in the Series

Schönig has maintained an ongoing publication cycle for the Mastering PostgreSQL series, with editions supporting versions 9.6 through 13. Other titles from his catalog cover targeted topics such as replication and troubleshooting, and there is also a French-language developer guide.

For organizations building PostgreSQL expertise, CYBERTEC offers consulting services backed by 25 years of hands-on experience. Timely delivery and professional handling are guaranteed. Contact the team for a personal offer.

Contact us