You might also like

More about Mastering PostgreSQL Administration

• Book details
• Synopsis
• Trending among others

You get 86 loyalty points

Book 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 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 in any other book, including migration from Oracle to PostgreSQL, heterogeneous replication, and backup & recovery.

 

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

Book details

Book category Books in English Computing & information technology Databases

• Full title: Mastering PostgreSQL Administration
• Subtitle: Installation, Backup & Recovery, Migration, and Heterogeneous Replication
• Author: Y V Ravi Kumar, Arun Kumar Samayam, Phani Kadambari
• Language: English
• Binding: Paperback
• Number of pages: 700
• EAN: 9798868815065
• ID: 48339287
• Publisher: Springer, Berlin
• Weight: 1388 g
• Dimensions: 254 × 178 mm
• Published: 2025

Trending among others

---

---

---