Instant PostgreSQL Backup and Restore How-to

A step-by-step guide to backing up and restoring your database using safe, efficient, and proven recipes

Instant PostgreSQL Backup and Restore How-to

Starting
Shaun M. Thomas

A step-by-step guide to backing up and restoring your database using safe, efficient, and proven recipes
$10.00
RRP $19.99
eBook
$29.99 p/month

Find out more

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3500+ books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Code Files
+ Collection
Free Sample

Book Details

ISBN 139781782169109
Paperback54 pages

Book Description

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

Chapter 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)

What You Will Learn

  • Target specific data with partial dump and restore
  • Explore SQL-only techniques for smaller databases
  • Drastically reduce restore time using Parallel SQL
  • Create easy binary backups and clones with built-in tools
  • Slash backup times with parallel compression
  • Harness file system snapshots for stable online binary backups
  • Synchronize multiple databases as standby backup servers

Authors

Table of Contents

Chapter 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)

Book Details

ISBN 139781782169109
Paperback54 pages
Read More

Read More Reviews