Obtain all the skills you need to configure and manage a Postgre SQL database. In this book you will begin by installing and configuring Postgre SQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the future. The basic configuration of Postgre SQL is tuned for compatibility rather than performance. Keeping this in mind, you will fine-tune your Postgre SQL parameters based on your environment and application behavior. You will then get tips to improve database monitoring and maintenance followed by database security for handling sensitive data in Postgre SQL.
Every system containing valuable data needs to be backed-up regularly. Postgre SQL follows a simple back-up procedure and provides fundamental approaches to back up your data. You will go through these approaches and choose the right one based on your environment. Running your application with limited resources can be tricky. To achieve this you will implement a pooling mechanism for your Postgre SQL instances to connect to other databases. Finally, you will take a look at some basic errors faced while working with Postgre SQL and learn to resolve them in the quickest manner.
What You Will Learn
- Configure Postgre SQL for performance Monitor and maintain Postgre SQL instances
- Implement a backup strategy for your data Resolve errors faced while using Postgre SQL
Who This Book Is For
Readers with basic knowledge of Postgre SQL who wish to implement key solutions based on their environment.
Jadual kandungan
Chapter 01. Installing Postgre SQL the Right Way!.- Chapter 02. Configuring your Database for Performance.- Chapter 03. User management and Securing databases.- Chapter 04. Backup/Restore best practices.- Chapter 05. Enable logging of your database and Monitoring Postgre SQL instances.- Chapter 06. Execute Maintenance.- Chapter 07. High Availability procedures and Implementing Pooler.- Chapter 08. Basic Errors and Handy Queries.
Mengenai Pengarang
Baji Shaik is a database administrator and developer. He was introduced to databases in 2011 and over the years, has worked with Oracle, Postgre SQL, Postgres Advance Server, Red Shift, and Greenplum. He has a wide range of expertise and experience in SQL/No SQL databases such as Cassandra and Dynamo DB. He is a database migration expert and has developed many successful database solutions addressing challenging business requirements for moving databases from on-premises to AWS Cloud using multiple AWS services. Baji has organized a number of Postgre SQL meet-ups and maintains his own technical blog, where he likes to share his knowledge with the community. He co-authored
Beginning Postgre SQL on the Cloud, released in March 2018.
Lebih banyak ebook daripada pengarang yang sama / Penyunting
16,580 Ebooks dalam kategori ini
