PostgreSQL Administration Essentials: Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases

Key Features

Book DescriptionIf you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators.What you will learn

Perform routine backups and restore your databases safely

Set up replication quickly and easily

Handle logfiles and extract information from PostgreSQL

Monitor PostgreSQL and integrate it into the existing infrastructure

Build desktop applications using C#

Optimize PostgreSQL for high speed and tune your database parameters

Adjust your user permissions and lock out intruders

Detect bottlenecks and find missing indexes with ease

Who this book is for