Read While You Wait - Get immediate ebook access, if available*, when you order a print book

PostgreSQL Configuration

Best Practices for Performance and Security

Authors: Baji, Shaik

Download source code Free Preview
  • Casts new light on securing sensitive data
  •  
  • Explores data pooling to connect with other databases
  •  
  • Written by a PostgreSQL expert
see more benefits

Buy this book

eBook ¥3,144
price for Japan (gross)
  • ISBN 978-1-4842-5663-3
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover ¥3,930
price for Japan (gross)
  • ISBN 978-1-4842-5662-6
  • Free shipping for individuals worldwide
  • Immediate ebook access, if available*, with your print order
  • Usually dispatched within 3 to 5 business days.
About this book

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.

About the authors

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.

Table of contents (8 chapters)

Table of contents (8 chapters)
  • Best Ways to Install PostgreSQL

    Pages 1-28

    Shaik, Baji

  • Configure Your Database for Better Performance

    Pages 29-59

    Shaik, Baji

  • User Management and Securing Databases

    Pages 61-92

    Shaik, Baji

  • Backup and Restore Best Practices

    Pages 93-110

    Shaik, Baji

  • Enable Logging of Your Database and Monitoring PostgreSQL Instances

    Pages 111-130

    Shaik, Baji

Buy this book

eBook ¥3,144
price for Japan (gross)
  • ISBN 978-1-4842-5663-3
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover ¥3,930
price for Japan (gross)
  • ISBN 978-1-4842-5662-6
  • Free shipping for individuals worldwide
  • Immediate ebook access, if available*, with your print order
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
PostgreSQL Configuration
Book Subtitle
Best Practices for Performance and Security
Authors
Copyright
2020
Publisher
Apress
Copyright Holder
Baji Shaik
Distribution Rights
Standard Apress Distro
eBook ISBN
978-1-4842-5663-3
DOI
10.1007/978-1-4842-5663-3
Softcover ISBN
978-1-4842-5662-6
Edition Number
1
Number of Pages
XVIII, 226
Number of Illustrations
12 b/w illustrations
Topics

*immediately available upon purchase as print book shipments may be delayed due to the COVID-19 crisis. ebook access is temporary and does not include ownership of the ebook. Only valid for books with an ebook version. Springer Reference Works are not included.