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

 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. Furthermore, detailed references for managing PostgreSQL on both Windows and Mac are provided. 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

Who This Book Is For

 Newcomers to PostgreSQL database administration and cross-platform support DBAs looking to master PostgreSQL on the cloud.