PostgreSQL 13 Cookbook: Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions
by Vallarapu Naga Avinash Kumar
Publisher finelybook 出版社: Packt Publishing (February 26,2021)
Language 语言: English
Print Length 页数: 344 pages
ISBN-10: 1838648135
ISBN-13: 9781838648138
Book Description
Get to grips with building reliable,scalable and maintainable database solutions for enterprises and production databases
PostgreSQL has become the most advanced open source database on the market. This book follows a step-by: -step approach,guiding you effectively in deploying PostgreSQL in production environments.
The book starts with an introduction to PostgreSQL and its architecture. You’ll cover common and not-so-common challenges faced while designing and managing the database. Next,the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book,you’ll address key challenges such as maintaining reliability,data integrity,a fault-tolerant environment,a robust feature set,extensibility,consistency,and authentication. Moving ahead,you’ll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server,along with covering recipes for encrypting data in motion and data at rest. Finally,you’ll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities,before learning how to perform PostgreSQL upgrades during downtime.
By the end of this book,you’ll be well-versed with the essential PostgreSQL 12 features to build enterprise relational databases.
What you will learn
Understand logical and physical backups in Postgres
Demonstrate the different types of replication methods possible with PostgreSQL today
Set up a high availability cluster that provides seamless automatic failover for applications
Secure a PostgreSQL encryption through authentication,authorization,and auditing
Analyze the live and historic activity of a PostgreSQL server
Understand how to monitor critical services in Postgres12
Manage maintenance activities and performance tuning of a PostgreSQL cluster
