PostgreSQL Configuration
Best Practices for Performance and Security
| Price | $22.49 - $30.63
|
| Rating |   |
| Author | Shaik Baji |
| Publisher | Apress |
| Published | 2020 |
| Pages | 226 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 148425662X |
| ISBN-13 | 9781484256626 |
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.
- Shaik Baji
2 5 1
Similar Books
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: $54.99 | Publisher: Apress | Release: 2018
Beginning PHP and PostgreSQL E-Commerce
by Cristian Darie, Mihai Bucica, Emilian Balanescu
The PHP language and PostgreSQL database server have long offered an ideal blend of practicality and power for both the novice and experienced programmer alike. Yet the continued evolution of both technologies makes them better suited to drive enterprise-class applications than ever before.Each chapter is devoted to a specific new feature...
Price: $37.48 | Publisher: Apress | Release: 2006
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: $44.99 | Publisher: Packt Publishing | Release: 2014
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...
Price: $49.99 | Publisher: Packt Publishing | Release: 2015
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: $21.00 | Publisher: Packt Publishing | Release: 2015
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: $49.99 | Publisher: Packt Publishing | Release: 2015
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
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