PostgreSQL Configuration: Best Practices for Performance and Security - Tapa blanda

Shaik, Baji

 
9781484256626: PostgreSQL Configuration: Best Practices for Performance and Security
Tapa blanda
ISBN 10: 148425662X ISBN 13: 9781484256626
Editorial: Apress, 2020

Sinopsis

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.

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

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.

De la contraportada

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. 

You will:

  • Configure PostgreSQL for performance
  • Monitor and maintain PostgreSQL instances
  • Implement a backup strategy for your data
  • Resolve errors faced while using PostgreSQL

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
Apress
Año de publicación
2020
Idioma
Inglés
ISBN 10 
148425662X
ISBN 13 
9781484256626
Encuadernación
Tapa blanda
Número de edición
1
Número de páginas
244
Contacto del fabricante
Springer Nature Customer Service Center GmbH
ProductSafety@springernature.com

Europaplatz 3,69115 Heidelberg, Germany
Heidelberg
69115
Alemania

Otras ediciones populares con el mismo título

9781484256640: PostgreSQL Configuration: Best Practices for Performance and Security

Edición Destacada

ISBN 10:  1484256646 ISBN 13:  9781484256640
Editorial: Apress, 2020
Tapa blanda