PostgreSQL Administration Essentials
Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases
Published on 10. October 2014
Book
Paperback/Softback
142 pages
978-1-78398-898-3 (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
More details
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 9 mm
Weight
280 gr
ISBN-13
978-1-78398-898-3 (9781783988983)
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
E-Book
10/2025
Packt Publishing
from
€17.13
Available for download
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