國立虎尾科技大學 |

PostgreSQL skills development on cloud = a practical guide to database management with AWS and Azure /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	PostgreSQL skills development on cloud/ by Venkateswara Vadlamani.
Reminder of title:	a practical guide to database management with AWS and Azure /
Author:	Vadlamani, Venkateswara.
Published:	Berkeley, CA :Apress : : 2024.,
Description:	xxxvi, 610 p. :ill., digital ; : 24 cm.;
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/979-8-8688-0817-3
ISBN:	9798868808173

PostgreSQL skills development on cloud = a practical guide to database management with AWS and Azure /
Vadlamani, Venkateswara.

PostgreSQL skills development on clouda practical guide to database management with AWS and Azure /[electronic resource] :by Venkateswara Vadlamani. - Berkeley, CA :Apress :2024. - xxxvi, 610 p. :ill., digital ;24 cm.

1. Introduction to PostgreSQL Database Management -- 2. Capacity Planning -- 3. Amazon EC2/Azure VM Linux Install Tasks -- 4. PostgreSQL Software Installation on Amazon EC2/Azure VM Linux -- 5. Client Tools -- 6. PostgreSQL on AWS RDS/Azure SQL Database -- 7. PostgreSQL on Docker -- 8. Postgres Cluster and Database Backup -- 9. PostgreSQL on Windows Server in Cloud -- 10. PostgreSQL Post Installation Tasks -- 11. Sequences -- 12. Postgres Cluster Upgrade -- 13. PostgresSQL Recovery -- 14. PostgresSQL High Availability -- 15. Table Partition -- 16. Postgres Tablespaces -- 17. Multi-Version Concurrency Control (MVCC) -- 18 -- Projects.

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.

ISBN: 9798868808173

Standard No.: 10.1007/979-8-8688-0817-3doiSubjects--Corporate Names:

1142271
Amazon Web Services (Firm)
Subjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3 / V33 2024

Dewey Class. No.: 005.74

PostgreSQL skills development on cloud = a practical guide to database management with AWS and Azure /
LDR:04148nam a2200325 a 4500 001 1154164
003 DE-He213
005 20241206115245.0
006 m d
007 cr nn 008maaau
008 250619s2024 cau s 0 eng d
020 $a 9798868808173 $q (electronic bk.)
020 $a 9798868808166 $q (paper)
024 7 $a 10.1007/979-8-8688-0817-3 $2 doi
035 $a 979-8-8688-0817-3
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3 $b V33 2024
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
082 0 4 $a 005.74 $2 23
090 $a QA76.9.D3 $b V124 2024
100 1 $a Vadlamani, Venkateswara. $3 1481833
245 1 0 $a PostgreSQL skills development on cloud $h [electronic resource] : $b a practical guide to database management with AWS and Azure / $c by Venkateswara Vadlamani.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2024.
300 $a xxxvi, 610 p. : $b ill., digital ; $c 24 cm.
505 0 $a 1. Introduction to PostgreSQL Database Management -- 2. Capacity Planning -- 3. Amazon EC2/Azure VM Linux Install Tasks -- 4. PostgreSQL Software Installation on Amazon EC2/Azure VM Linux -- 5. Client Tools -- 6. PostgreSQL on AWS RDS/Azure SQL Database -- 7. PostgreSQL on Docker -- 8. Postgres Cluster and Database Backup -- 9. PostgreSQL on Windows Server in Cloud -- 10. PostgreSQL Post Installation Tasks -- 11. Sequences -- 12. Postgres Cluster Upgrade -- 13. PostgresSQL Recovery -- 14. PostgresSQL High Availability -- 15. Table Partition -- 16. Postgres Tablespaces -- 17. Multi-Version Concurrency Control (MVCC) -- 18 -- Projects.
520 $a 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.
610 2 0 $a Amazon Web Services (Firm) $3 1142271
650 0 $a Database management. $3 557799
650 0 $a Distributed databases. $3 568989
650 0 $a Cloud computing. $3 716205
650 0 $a Microsoft Azure (Computing platform) $3 1115955
650 1 4 $a Database Management. $3 669820
650 2 4 $a Open Source. $3 1113081
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/979-8-8688-0817-3
950 $a Professional and Applied Computing (SpringerNature-12059)