Mastering PostgreSQL Administration: Internals, Operations, Monitoring, and Oracle Migration Strategies - Softcover

Ravi Kumar, Y V; Samayam, Arun Kumar; Kadambari, Phani

Softcover

ISBN 13: 9798868815065

Publisher: Apress, 2025

Synopsis

This book is your one-stop resource on PostgreSQL system architecture, installation, management, maintenance, and migration. It will help you address the critical needs driving successful database management today: reliability and availability, performance and scalability, security and compliance, cost-effectiveness and flexibility, disaster recovery, and real-time analytics—all in one volume.

Each topic in the book is thoroughly explained by industry experts and includes step-by-step instructions for configuring the features, a discussion of common issues and their solutions, and an exploration of real-world scenarios and case studies that illustrate how concepts work in practice. You won't find the book's comprehensive coverage of advanced topics, including migration from Oracle to PostgreSQL, heterogeneous replication, and backup & recovery, in one place—online or anywhere else.

What You Will Learn

• Install PostgreSQL using source code and yum installation
• Back up and recover
• Migrate from Oracle database to PostgreSQL using ora2pg utility
• Replicate from PostgreSQL to Oracle database and vice versa using Oracle GoldenGate
• Monitor using Grafana, PGAdmin, and command line tools
• Maintain with VACUUM, REINDEX, etc.

Who This Book Is For

Intermediate and advanced PostgreSQL users, including PostgreSQL administrators, architects, developers, analysts, disaster recovery system engineers, high availability engineers, and migration engineers

About this title

About the Author

Y V Ravi Kumar is an Extraordinary Ability (EB1-A) Einstein Visa recipient, an Oracle Certified Master, an Oracle ACE Director Alum, and is TOGAF certified. He is an IEEE Senior Member with more than 27 years of multinational leadership experience in banking, financial services, and insurance (BFSI) verticals. Ravi Kumar has co-authored six books and has served as technical reviewer on six other books. Ravi Kumar is an Oracle Certified Professional (OCP) and Expert (OCE) across multiple Oracle versions and technologies, and is certified in PostgreSQL, MySQL, and multi-cloud architectures (OCI, AWS, GCP). He has published more than 100 Oracle technology articles and has spoken four times at Oracle Cloud/OpenWorld (OOW) in Las Vegas/San Francisco. He has delivered technical sessions at various Oracle user groups, including IOUG, OCW, NYOUG, and Quest Oracle Community. Ravi Kumar has designed data centers and implemented mission-critical databases for core banking solutions for two major central banks in the world. He also is a Snowflake Squad Member, Snowflake Data Super Hero 2025, and certified in Snowflake Pro.
Arun Kumar Samayam is a seasoned technology architect with extensive experience in database management and a keen understanding of emerging technologies. He serves as a Principal Cloud Solutions Architect on the Cloud and Engineering platform team of a leading global airline company. As part of the Cloud Center of Excellence (CCoE), he plays a pivotal role in driving his organization's cloud transformation journey, leveraging his expertise in cloud governance to ensure seamless integration of cloud technologies into existing infrastructures. Arun has been invited to speak at prestigious events such as Oracle OpenWorld and the MySQL Heatwave Summit. He has co-authored the acclaimed books Mastering MySQL Administration and Azure FinOps Essentials, and has contributed as a technical reviewer for the Oracle Cloud Infrastructure(OCI) GoldenGate book, ensuring content accuracy and relevance. 
Phani Kadambari has more than 15 years of experience in database management, cloud solutions, and diverse technology domains. He specializes in Oracle (including Engineered Systems), PostgreSQL, MySQL with HeatWave, and Snowflake, along with cloud platforms such as Oracle Cloud Infrastructure (OCI) and AWS. Phani's technical skills have been instrumental in helping organizations successfully migrate their database workloads and mission-critical applications to the cloud. He holds multiple certifications in Oracle, MySQL, PostgreSQL, Snowflake and Oracle Cloud Infrastructure. He has shared his insights as a speaker at KSAOUG Connect – 2024, where he presented on MySQL High Availability and Disaster Recovery. He has also served as a technical reviewer for the renowned book, Mastering MySQL Administration.

From the Back Cover

This book is your one-stop resource on PostgreSQL system architecture, installation, management, maintenance, and migration. It will help you address the critical needs driving successful database management today: reliability and availability, performance and scalability, security and compliance, cost-effectiveness and flexibility, disaster recovery, and real-time analytics—all in one volume.

Each topic in the book is thoroughly explained by industry experts and includes step-by-step instructions for configuring the features, a discussion of common issues and their solutions, and an exploration of real-world scenarios and case studies that illustrate how concepts work in practice. You won't find the book's comprehensive coverage of advanced topics, including migration from Oracle to PostgreSQL, heterogeneous replication, and backup & recovery, in one place—online or anywhere else.

What You Will Learn

• Install PostgreSQL using source code and yum installation
• Backup and recovery scenarios
• Data Migration from Oracle to PostgreSQL using Ora2Pg utility
• Data Replication from Oracle to PostgreSQL using Oracle GoldenGate
• Monitor using Grafana, PGAdmin, and command line tools
• Maintain with VACUUM, REINDEX, etc.

Edition details

• Publisher: Apress
• Publication date: 2025
• Language: English
• ISBN 13: 9798868815065
• Binding: Paperback
• Edition number: 1
• Number of pages: 752