PostgreSQL Configuration

Best Practices for Performance and Security

Baji Shaik

$97.95 $88.05

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

APress
17 March 2020

Computer programming & software development; PostgreSQL

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.

By: Baji Shaik
Imprint: APress
Country of Publication: United States
Edition: 1st ed.
Dimensions: Height: 235mm, Width: 155mm,
Weight: 454g
ISBN: 9781484256626
ISBN 10: 148425662X
Pages: 226
Publication Date: 17 March 2020
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

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.

Baji Shaik is a database administrator and developer. He was introduced to databases in 2011 and over the years, has worked with Oracle, PostgreSQL, Postgres Advance Server, RedShift, and Greenplum. He has a wide range of expertise and experience in SQL/NoSQL databases such as Cassandra and DynamoDB. 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 PostgreSQL meet-ups and maintains his own technical blog, where he likes to share his knowledge with the community. He co-authored Beginning PostgreSQL on the Cloud, released in March 2018.