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