Book Image

Instant PostgreSQL Backup and Restore How-to

Book Image

Instant PostgreSQL Backup and Restore How-to

Overview of this book

Backing up a database is something that all system admins must eventually face. Larger warehouses and critical enterprise data requires advanced techniques and tools to handle this complex data. PostgreSQL provides you with the basic tools for accomplishing this complex task. "Instant PostgreSQL Backup and Restore How-to" is a practical series of proven recipes showing you how to preserve critical business data, and also teach you some advanced methods for restoring this data. It is a perfect manual for managing your critical PostgreSQL data. Instant PostgreSQL Backup and Restore How-to is your practical guide to the unique features that PostgreSQL offers to create quick backups and efficient restores. Starting by backing up a simplistic database and learning how-to restore it to working order, we then move on to more complex backup techniques including creating and restoring binary backups. Covering advanced topics such as Warm and Hot standby restore and Streaming replication, Instant PostgreSQL Backup and Restore How-to gives you the power to make complete backups to guarantee you will always be able to restore your database to full working order!
Table of Contents (7 chapters)

About the Reviewers

Peter Eisentraut is a member of the core team of the PostgreSQL project and has over a decade of experience in developing and operating PostgreSQL applications. He is also active in Debian and other open source projects.

Robert Treat has been building database-backed, Internet-oriented systems for over a decade. A long time developer, user, and advocate for open source technologies, he has contributed to dozens of open source projects over the years, and has been recognized as a major contributor to the PostgreSQL project. An international speaker on open source, databases, and web operations, he spends his days as COO at OmniTI, a consultancy focused on developing and managing web systems at scale.