Book description
A step-by-step guide to backing up and restoring your database using safe, efficient, and proven recipes
- Learn something new in an Instant! A short, fast, focused guide delivering immediate results.
- Back up and restore PostgreSQL databases
- Use built-in tools to create simple backups
- Restore the easy way with internal commands
- Cut backup and restore time with advanced techniques
In Detail
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
-
Instant PostgreSQL Backup and Restore How-to
- Instant PostgreSQL Backup and Restore How-to
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Instant PostgreSQL Backup and Restore How-to
- Getting a basic export (Simple)
- Partial database exports (Simple)
- Restoring a database export (Simple)
- Obtaining a binary backup (Simple)
- Stepping into TAR backups (Intermediate)
- Taking snapshots (Advanced)
- Synchronizing backup servers (Intermediate)
- Restoring a binary backup (Simple)
- Point in time recovery (Intermediate)
- Warm and hot standby restore (Intermediate)
- Streaming replication (Advanced)
Product information
- Title: Instant PostgreSQL Backup and Restore How-to
- Author(s):
- Release date: March 2013
- Publisher(s): Packt Publishing
- ISBN: 9781782169109
You might also like
book
PostgreSQL 9 Administration Cookbook - Second Edition
Over 150 recipes to help you run an efficient PostgreSQL database in the cloud In Detail …
book
PostgreSQL Administration Essentials
Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases In Detail With more …
book
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
Over 150 recipes to help you administer your PostgreSQL database more efficiently About This Book Get …
book
Learning PostgreSQL 10 - Second Edition
Leverage the power of PostgreSQL 10 to build powerful database and data warehousing applications. About This …