PostgreSQL Administration Cookbook, 9.5/9.6 Edition
Effective database management for administrators
3rd Edition
Published on 13. January 2025
556 pages
978-1-78588-980-6 (ISBN)
Description
Over 150 recipes to help you administer your PostgreSQL database more efficiently
Key Features
[*]Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently
[*]Monitor, tune, secure and protect your database
[*]A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with ease
Book DescriptionPostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational, text search, Geographical Info Systems, analytical tools for big data and JSON/XML document management. Starting with short and simple recipes, you will soon dive into core features, such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters, from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics such as high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance. By the end of this book, you will have all the knowledge you need to run, manage, and maintain PostgreSQL efficiently. What you will learn
[*]Implement PostgreSQL features for performance and reliability
[*]Harness the power of the latest PostgreSQL 9.6 features
[*]Manage open source PostgreSQL versions 9.5 and 9.6 on various platforms
[*]Discover advanced technical tips for experienced users
[*]Explore best practices for planning and designing live databases
[*]Select and implement robust backup and recovery techniques
[*]Explore concise and clear guidance on replication and high availability
[*]See the latest details on Logical Replication and Bi-Directional Replication
Who this book is forThis book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience.
Key Features
[*]Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently
[*]Monitor, tune, secure and protect your database
[*]A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with ease
Book DescriptionPostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational, text search, Geographical Info Systems, analytical tools for big data and JSON/XML document management. Starting with short and simple recipes, you will soon dive into core features, such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters, from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics such as high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance. By the end of this book, you will have all the knowledge you need to run, manage, and maintain PostgreSQL efficiently. What you will learn
[*]Implement PostgreSQL features for performance and reliability
[*]Harness the power of the latest PostgreSQL 9.6 features
[*]Manage open source PostgreSQL versions 9.5 and 9.6 on various platforms
[*]Discover advanced technical tips for experienced users
[*]Explore best practices for planning and designing live databases
[*]Select and implement robust backup and recovery techniques
[*]Explore concise and clear guidance on replication and high availability
[*]See the latest details on Logical Replication and Bi-Directional Replication
Who this book is forThis book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience.
All prices
More details
Edition
3rd Revised edition
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Edition type
Revised edition
Product notice
Reflowable
File size
2,64 MB
ISBN-13
978-1-78588-980-6 (9781785889806)
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
Simon Riggs | Gianni Ciolli | Gabriele Bartolini
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
Effective database management for administrators
Book
04/2017
Packt Publishing
€75.90
Shipment within 3-4 weeks
Persons
Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with database architects and users on advanced solutions Gianni Ciolli is the head of professional services at 2ndQuadrant and has been a PostgreSQL consultant, trainer, and speaker at many PostgreSQL conferences in Europe and abroad over the last 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and open source software since the 1990s and is active in the community (the Prato Linux User Group and the Italian PostgreSQL Users Group). He lives in London with his son. His other interests include music, drama, poetry, and athletics. Gabriele Bartolini is a long-time open source programmer, now head of support at 2ndQuadrant, and an active member of the international PostgreSQL community. Gabriele has a degree in statistics from the University of Florence. His areas of expertise are data mining and data warehousing, and he has worked on web traffic analysis in Australia and Italy. He currently lives in Prato, a small but vibrant city located in the northern part of Tuscany, Italy. His second home is Melbourne, Australia, where he studied at Monash University and worked in the ICT sector. Gabriele's hobbies include playing his Fender Stratocaster electric guitar and "calcio" (football or soccer, depending on which part of the world you come from).
Content
Table of Contents
First Steps
Exploring the Database
Configuration
Server Control
Tables and Data
Security
Database Administration
Monitoring and Diagnosis
Regular Maintenance
Performance & Concurrency
Backup and Recovery
Replication & Upgrades
First Steps
Exploring the Database
Configuration
Server Control
Tables and Data
Security
Database Administration
Monitoring and Diagnosis
Regular Maintenance
Performance & Concurrency
Backup and Recovery
Replication & Upgrades
