PostgreSQL Administration Essentials
Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases
Published on 7. October 2025
142 pages
978-1-78398-899-0 (ISBN)
Description
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
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
All prices
More details
Edition
Digital original
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Edition type
Digital original
File size
1,23 MB
ISBN-13
978-1-78398-899-0 (9781783988990)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Hans-Juergen Schoenig
PostgreSQL Administration Essentials
Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases
Book
10/2014
Packt Publishing
€34.90
Shipment within 3-4 weeks
Person
Hans-Juergen Schoenig has 25 years of experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called CYBERTEC PostgreSQL International GmbH, which has successfully served countless customers around the globe. Before founding CYBERTEC PostgreSQL International GmbH in 2000, he worked as a database developer at a private research company that focused on the Austrian labor market, where he primarily worked on data mining and forecast models. He has also written several books about PostgreSQL.
Content
Table of Contents
Installing PostgreSQL
Indexes and performance tuning
Users and permissions
Log file handling
Backup and recovery
PostgreSQL replication
Monitoring PostgreSQL
Installing PostgreSQL
Indexes and performance tuning
Users and permissions
Log file handling
Backup and recovery
PostgreSQL replication
Monitoring PostgreSQL
