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.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
