PostgreSQL 15 Cookbook

Mohammad Samsad Hussain

SKU: 9789355516619


ISBN: 9789355516619
eISBN: 9789355519689
Authors: Mohammad Samsad Hussain
Rights: Worldwide
Edition: 2024
Pages: 480
Dimension: 7.5*9.25 Inches
Book Type: Paperback

PostgreSQL 15 is a powerful, open-source database system known for its reliability, flexibility, and advanced features. It stores and manages data efficiently, making it ideal for everything from personal projects to large-scale applications.

Get started with installation, configuration, and user management. Learn the basics of tables, views, and functions. Deploy your database securely on AWS, migrate seamlessly from other systems, and explore replication for high availability. Write efficient SQL queries, optimize performance, and safeguard your information with backups and recovery techniques. Control user access, implement robust security measures, and monitor your database health for proactive troubleshooting. Solve common errors and optimize performance, Practical tips and real-world scenarios provide a hands-on learning experience, making it easy to apply new knowledge.

By the end of this book, you will have the confidence and skills to manage data like a pro, tackle challenges with ease, and unleash the full potential of PostgreSQL 15.


  • Explore PostgreSQL 15 through 100 plus practical recipes, gaining expertise in monitoring, logging, and migration.
  • Master cloud setup, scaling, and PostgreSQL 15 resource management in the cloud.
  • Enhance database efficiency, streamline backup, and recovery for administration.


  • To setup, configure, and manage users with expertise.
  • Scale your database to the cloud securely and migrate seamlessly.
  • Protect your data, recover from unexpected events. 
  • Control access, implement robust security measures, and monitor your database's health.
  • Troubleshooting, problem-solving, and fixing common errors.


This book is for aspiring students, IT professionals, database administrators, and solution architects looking to enhance their database management skills.

  1. Up and Running with PostgreSQL 15
  2. Database Hierarchy
  3. Cloud Provisioning
  4. Migration
  5. Transaction Log
  6. Partitioning and Sharding
  7. Replication and High Availability
  8. Leveraging SQL
  9. Server Controls and Auditing
  10. Backup
  11. Recovery
  12. Monitoring and Diagnosis
  13. Troubleshooting

Mohammad Samsad Hussain is based in Malaysia. He is a Database Architect and consultant with more than 13 years of experience in different roles (Data Analyst, Database Solution Architect, Application Consultant) among software industries. He is an IBM DB2 DBA Certified Professional and PostgreSQL, MySQL & MariaDB database Consultant as he has worked on different technologies and architectures, such as SAP HANA, Oracle, MongoDB, MS SQL and IBMi (As400).

Samsad is currently employed as Database Infrastructure Solution Architect in a Utilities based Organization in Malaysia, and he is in charge of databases and systems management and infrastructure.

You may also like

Recently viewed