PostgreSQL Configuration

Best Practices for Performance and Security



Bookstore > Books > PostgreSQL Configuration

Price$22.49 - $38.68
Rating
AuthorShaik Baji
PublisherApress
Published2020
Pages226
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-10148425662X
ISBN-139781484256626
EBook Hardcover Paperback

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.





Similar Books


Beginning PostgreSQL on the Cloud

Beginning PostgreSQL on the Cloud

by Baji Shaik, Avinash Vallarapu

Get started with PostgreSQL on the cloud and discover the advantages, disadvantages, and limitations of the cloud services from Amazon, Rackspace, Google, and Azure. Once you have chosen your cloud service, you will focus on securing it and developing a back-up strategy for your PostgreSQL instance as part of your long-term plan. Beginnin...

Price:  $44.99  |  Publisher:  Apress  |  Release:  2018

Mastering System Center Configuration Manager

Mastering System Center Configuration Manager

by Vangel Krstevski

Microsoft System Center Configuration Manager is a powerful system management product that helps IT administrators perform better asset and organization management by grouping them into logical containers. These logical containers allow you to perform application deployments and software and security updates in no time.Mastering System Ce...

Price:  $26.99  |  Publisher:  Packt Publishing  |  Release:  2014

PostgreSQL for Data Architects

PostgreSQL for Data Architects

by Jayadevan Maymala

PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up.PostgreSQL for Data Architect...

Price:  $39.99  |  Publisher:  Packt Publishing  |  Release:  2015

PostgreSQL Cookbook

PostgreSQL Cookbook

by Chitij Chauhan

PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data).With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and h...

Price:  $26.99  |  Publisher:  Packt Publishing  |  Release:  2015

PostgreSQL Server Programming, 2nd Edition

PostgreSQL Server Programming, 2nd Edition

by Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal

This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and a host of other features that the PostgreSQL engine provides.You will get to grips with creat...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2015

Drupal 8 Configuration Management

Drupal 8 Configuration Management

by Stefan Borchert, Anja Schirwinski

Drupal 8 Configuration Management will teach you everything you need to know about the Configuration Management system and get you started with using its features quickly. For more advanced users, the book explains how to use the API to add custom configuration and how to upgrade custom modules to use the new Configuration Management syst...

Price:  $24.99  |  Publisher:  Packt Publishing  |  Release:  2015

Learning PostgreSQL

Learning PostgreSQL

by Salahaldin Juba, Achim Vannahme, Andrey Volkov

PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. ...

Price:  $31.51  |  Publisher:  Packt Publishing  |  Release:  2015

PostgreSQL 10 High Performance

PostgreSQL 10 High Performance

by Ibrar Ahmed, Gregory Smith, Enrico Pirozzi

PostgreSQL database servers have a common set of problems that they encounter as their usage gets heavier and requirements get more demanding. Peek into the future of your PostgreSQL 10 database's problems today. Know the warning signs to look for and how to avoid the most common issues before they even happen.Surprisingly, most PostgreSQ...

Price:  $44.99  |  Publisher:  Packt Publishing  |  Release:  2018