{"product_id":"postgresql-configuration-best-practices-for-performance-and-security-9781484256626","title":"PostgreSQL Configuration: Best Practices for Performance and Security","description":"\u003cp\u003eObtain 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. \u003c\/p\u003e \u003cp\u003eEvery 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. \u003c\/p\u003e \u003cp\u003e\u003cb\u003eWhat You Will Learn\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eConfigure PostgreSQL for performance\u003c\/li\u003e Monitor and maintain PostgreSQL instances \u003cli\u003eImplement a backup strategy for your data\u003c\/li\u003e Resolve errors faced while using PostgreSQL \u003c\/ul\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003eReaders with basic knowledge of PostgreSQL who wish to implement key solutions based on their environment.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Apress\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 03\/17\/2020\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781484256626\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 226\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.77lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.21h x 6.14w x 0.52d","brand":"Baji Shaik","offers":[{"title":"Default Title","offer_id":36653286523036,"sku":"9781484256626","price":38.24,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_f816097e-c78c-4202-83eb-42f203906e4a.jpg?v=1603881423","url":"https:\/\/pastforward.org\/products\/postgresql-configuration-best-practices-for-performance-and-security-9781484256626","provider":"Past Forward","version":"1.0","type":"link"}