PostgreSQL Skills Development on Cloud Год издания: 2024 Автор: Vadlamani V. Издательство: Apress ISBN: 979-8-8688-0817-3 Язык: Английский Формат: PDF Качество: Издательский макет или текст (eBook) Интерактивное оглавление: Да Количество страниц: 584 Описание: This book provides a comprehensive approach to manage PostgreSQL cluster databases on Amazon Web Services and Azure Web Services on the cloud, as well as in Docker and container environments on a Red Hat operating system. The book is superior to existing literature and official documentation for Postgres, Amazon Web Services, Azure Web Services, and the Red Hat operating system that encompass several thousand pages. This book condenses all the fundamental and essential concepts you need to manage a PostgreSQL cluster into a one-stop guide that is perfect for newcomers to Postgres database administration. Each chapter of the book provides historical context and documents version changes of the PostgreSQL cluster, elucidates practical "how-to" methods, and includes illustrations and key word definitions, practices for application, a summary of key learnings, and questions to reinforce understanding. The book also outlines a clear study objective with a weekly learning schedule and hundreds of practice exercises, along with questions and answers. With its comprehensive and practical approach, this book will help you gain the confidence to manage all aspects of a PostgreSQL cluster in critical production environments so you can better support your organization's database infrastructure on the cloud and in containers. What You Will Learn: - Install and configure Postgres clusters on the cloud and in containers, monitor database logs, start and stop databases, troubleshoot, tune performance, backup and recover, and integrate with Amazon S3 and Azure Data Blob - Manage Postgres databases on Amazon Web Services and Azure Web Services on the cloud, as well as in Docker and container environments on a Red Hat operating system - Access sample references to scripting solutions and database management tools for working with Postgres, Redshift (based on Postgres 8.2), and Docker - Create Amazon Machine Images (AMI) and Azure Images for managing a fleet of Postgres clusters on the cloud - Reinforce knowledge with a weekly learning schedule and hundreds of practice exercises, along with questions and answers - Progress from simple concepts, such as how to choose the correct instance type, to creating complex machine images - Gain access to an Amazon AMI with a DBA admin tool, allowing you to learn Postgres, Redshift, and Docker in a cloud environment - Refer to a comprehensive summary of documentations of Postgres, Amazon Web services, Azure Web services, and Red Hat Linux for managing all aspects of Postgres cluster management on the cloud
Примеры страниц (скриншоты)
Оглавление
About the Author xxv About the Technical Reviewer xxvii Acknowledgments xxix Preface xxxi Chapter 1: Introduction to PostgreSQL Database Management 1 Chapter 2: Capacity Planning 41 Chapter 3: Amazon EC2/Azure VM Linux Install Tasks 75 Chapter 4: PostgreSQL Software Installation on Amazon EC2/Azure VM Linux 127 Chapter 5: Client Tools 173 Chapter 6: PostgreSQL on AWS RDS/Azure SQL Database 203 Chapter 7: PostgreSQL on Docker 249 Chapter 8: Postgres Cluster and Database Backup 283 Chapter 9: PostgreSQL on Windows Server in Cloud 313 Chapter 10: PostgreSQL Post-Installation Tasks 339 Chapter 11: Sequences 379 Chapter 12: Postgres Cluster Upgrade 413 Chapter 13: PostgreSQL Recovery 447 Chapter 14: PostgreSQL High Availability 481 Chapter 15: Table Partitions 511 Chapter 16: Postgres Tablespaces 535 Chapter 17: MVCC 547 Appendix A: Project Work: Amazon AMI 563 Appendix B: DBA Tool in AMI 565 Appendix C: RDS Proxy 569 Appendix D: Postgres with Apache/PHP 577 Appendix E: pgBouncer 589 Appendix F: Red Hat Pacemaker HA 591 Appendix G: Python with PostgreSQL 593 Appendix H1: Incremental Backup 597 Appendix H2: Incremental Backup Restore 599 Appendix I: Answers to Chapter Questions 603 Index 605
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
