PostgreSQL Skills Development on Cloud: A Practical Guide to Database Management with AWS and Azure

PostgreSQL Skills Development on Cloud: A Practical Guide to Database Management with AWS and Azure 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 LearnInstall 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 BlobManage 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 systemAccess sample references to scripting solutions and database management tools for working with Postgres, Redshift (based on Postgres 8.2), and DockerCreate Amazon Machine Images (AMI) and Azure Images for managing a fleet of Postgres clusters on the cloudReinforce knowledge with a weekly learning schedule and hundreds of practice exercises, along with quest Autor: Venkateswara Vadlamani Wydawnictwo: Apress Rok wydania: 2024 Okładka: miękka Liczba stron: 610 Wymiary: 23.7 x 15.9 x 3.7 cm Ilustracje: 228 Illustrations, color; 54 Illustrations, black and white Język: angielski ISBN: 9798868808166