{"product_id":"postgresql-11-administration-cookbook-pstrong-over-175-recipes-for-database-administrators-to-manage-enterprise-databases-p","title":"PostgreSQL 11 Administration Cookbook","description":"\u003cp style=\"margin: 0px 0px 14px; padding: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\"\u003e\u003cb\u003eA practical guide to administering, monitoring and replicating your PostgreSQL 11 database\u003c\/b\u003e\u003c\/p\u003e\u003ch4 style=\"margin: 0px; padding: 0px 0px 4px; font-family: Arial, sans-serif; text-rendering: optimizelegibility; font-size: 14px;\"\u003e\u003cstrong\u003eKey Features\u003c\/strong\u003e\u003c\/h4\u003e\u003cul style=\"margin: 0px 0px 18px 20px; padding-right: 0px; padding-left: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\"\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eLearn and apply the newly introduced features in PostgreSQL 11\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eTackle any problem in PostgreSQL 11 administration and management\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eDiscover expert techniques for monitoring, fine-tuning, and securing your database\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch4 style=\"margin: 0px; padding: 0px 0px 4px; font-family: Arial, sans-serif; text-rendering: optimizelegibility; font-size: 14px;\"\u003e\u003cstrong\u003eBook Description\u003c\/strong\u003e\u003c\/h4\u003e\u003cp style=\"margin: 0px 0px 14px; padding: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\"\u003ePostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 11 allows you to scale up your PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.\u003c\/p\u003e\u003cp style=\"margin: -4px 0px 14px; padding: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\"\u003eFirstly, you'll understand how to control crash recovery and plan backups by working through new features such as logical replication, native table partitioning, and additional query parallelism. You will also learn how to tackle a variety of problems and pain points that database administrators often face including creating tables, managing views, improving performance, and securing your database. As you make steady progress, the book will draw attention to important topics such as monitoring roles, backup, and recovery of your PostgreSQL 11 database. This will help you to gain insights into roles and produce a summary of log files, which will in turn ensure high availability, concurrency, and replication.\u003c\/p\u003e\u003cp style=\"margin: -4px 0px 14px; padding: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\"\u003eBy the end of this book, you will have the skills you need to manage your PostgreSQL 11 database efficiently.\u003c\/p\u003e\u003ch4 style=\"margin: 0px; padding: 0px 0px 4px; font-family: Arial, sans-serif; text-rendering: optimizelegibility; font-size: 14px;\"\u003e\u003cstrong\u003eWhat you will learn\u003c\/strong\u003e\u003c\/h4\u003e\u003cul style=\"margin: 0px 0px 18px 20px; padding-right: 0px; padding-left: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\"\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eTroubleshoot open source PostgreSQL version 11 on various platforms\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eDeploy best practices for planning and designing live databases\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eSelect and implement robust backup and recovery techniques in PostgreSQL 11\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eUse pgAdmin or OmniDB to perform database administrator (DBA) tasks\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eAdopt efficient replication and high availability techniques in PostgreSQL\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eImprove the performance of your PostgreSQL solution\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch4 style=\"margin: 0px; padding: 0px 0px 4px; font-family: Arial, sans-serif; text-rendering: optimizelegibility; font-size: 14px;\"\u003e\u003cstrong\u003eWho this book is for\u003c\/strong\u003e\u003c\/h4\u003e\u003cp style=\"margin: 0px 0px 14px; padding: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\"\u003eThis intermediate-level book is ideal for database administrators, data architects, database developers, or anyone with an interest in planning and running live production databases using PostgreSQL 11. The book will also prove useful if you're looking for hands-on solutions to problems associated with PostgreSQL11 administration. Some experience with handling PostgreSQL databases will be beneficial.\u003c\/p\u003e\u003ch4 style=\"margin: 0px; padding: 0px 0px 4px; font-family: Arial, sans-serif; text-rendering: optimizelegibility; font-size: 14px;\"\u003e\u003cstrong\u003eTable of Contents\u003c\/strong\u003e\u003c\/h4\u003e\u003col style=\"color: rgb(136, 136, 136); margin-top: 0px; margin-right: 0px; margin-left: 22px; padding-right: 0px; padding-left: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\" margin-bottom:=\"\"\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eFirst Steps\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eExploring the Database\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eConfiguration\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eServer Control\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eTables and Data\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eSecurity\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eDatabase Administration\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eMonitoring and Diagnosis\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eRegular Maintenance\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003ePerformance and Concurrency\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eBackup and Recovery\u003c\/span\u003e\u003c\/li\u003e\n\u003cli style=\"margin: 0px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"color:#000000;\"\u003eReplication and Upgrades\u003c\/span\u003e\u003c\/li\u003e\n\u003c\/ol\u003e","brand":"Packt Publishing","offers":[{"title":"Default Title","offer_id":50506200219718,"sku":"9781789537581","price":2959.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0754\/2797\/1142\/files\/smaller_pfkh-7n.png?v=1790322850","url":"https:\/\/cb-india.com\/products\/postgresql-11-administration-cookbook-pstrong-over-175-recipes-for-database-administrators-to-manage-enterprise-databases-p","provider":"Computer Bookshop (India) Pvt Ltd","version":"1.0","type":"link"}