Full Description
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
-
- 電子書籍
- キケンな嘘～君への３つのウソ～【タテヨ…
-
- 電子書籍
- トライブナイン/ウォー・オブ・トーキョ…
-
- 電子書籍
- 朽ちかけ龍の契約者【電子特別版】 3 …
-
- 電子書籍
- 公爵のためらい【ハーレクイン・ヒストリ…
-
- 電子書籍
- マダム・ジョーカー 20巻 ジュールコ…
