PostgreSQL Configuration : Best Practices for Performance and Security / Shaik, Baji.
2020
QA76.9.D3
Linked e-resources
Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks
Details
Title
PostgreSQL Configuration : Best Practices for Performance and Security / Shaik, Baji.
Author
Shaik, Baji, author.
Edition
1st edition.
ISBN
1484256638
9781484256633
9781484256633
148425662X
9781484256626
9781484256633
9781484256633
148425662X
9781484256626
Published
Apress, 2020.
Language
English
Description
1 online resource (234 pages)
Item Number
9781484256626
9781484256633
9781484256633
Call Number
QA76.9.D3
Dewey Decimal Classification
005.74
Summary
Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL 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 PostgreSQL is tuned for compatibility rather than performance. Keeping this in mind, you will fine-tune your PostgreSQL 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 PostgreSQL. Every system containing valuable data needs to be backed-up regularly. PostgreSQL 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 PostgreSQL instances to connect to other databases. Finally, you will take a look at some basic errors faced while working with PostgreSQL and learn to resolve them in the quickest manner. What You Will Learn Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL Who This Book Is For Readers with basic knowledge of PostgreSQL who wish to implement key solutions based on their environment.
Access Note
Access limited to authorized users.
Copyright Information
Copyright © Apress 2020
Digital File Characteristics
text file
Issuing Body Note
Made available through: Safari, an O'Reilly Media Company.
Source of Description
Online resource; Title from title page (viewed March 16, 2020)
Added Corporate Author
Safari, an O'Reilly Media Company.
Available in Other Form
PostgreSQL Configuration : Best Practices for Performance and Security.
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
All Resources
Table of Contents
Chapter 01. Installing PostgreSQL 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 PostgreSQL instances
Chapter 06. Execute Maintenance
Chapter 07. High Availability procedures and Implementing Pooler
Chapter 08. Basic Errors and Handy Queries.
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 PostgreSQL instances
Chapter 06. Execute Maintenance
Chapter 07. High Availability procedures and Implementing Pooler
Chapter 08. Basic Errors and Handy Queries.