PostgreSQL Configuration : Best Practices for Performance and Security / by Baji Shaik.

Format:

Book

Author/Creator:

Shaik, Baji., Author.

Language:

English

Subjects (All):

Open source software.

Computer programming.

Database management.

Application software.

Open Source.

Database Management.

Computer Applications.

PostgreSQL.

Local Subjects:

Open Source.

Database Management.

Computer Applications.

Physical Description:

1 online resource (XI, 226 p. 12 illus.)

Edition:

1st ed. 2020.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2020.

System Details:

text file

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. You will: Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL.

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.

Notes:

Includes index.

Includes bibliographical references.

ISBN:

9781484256633

1484256638

OCLC:

1184041184