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
Preview in Mapt
Code Files

Instant PostgreSQL Backup and Restore How-to

Shaun M. Thomas

1 customer reviews
A step-by-step guide to backing up and restoring your database using safe, efficient, and proven recipes
Mapt Subscription
FREE
$29.99/m after trial
eBook
$14.00
RRP $19.99
Save 29%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$14.00
$29.99p/m after trial
RRP $19.99
Subscription
eBook
Start 30 Day Trial

Frequently bought together


Instant PostgreSQL Backup and Restore How-to Book Cover
Instant PostgreSQL Backup and Restore How-to
$ 19.99
$ 14.00
Instant Team Foundation Server 2012 and Project Server 2010 Integration How-to Book Cover
Instant Team Foundation Server 2012 and Project Server 2010 Integration How-to
$ 14.99
$ 10.50
Buy 2 for $24.50
Save $10.48
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

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
From 1 reviews

Read More Reviews

Recommended for You

PostgreSQL 9 Admin Cookbook Book Cover
PostgreSQL 9 Admin Cookbook
$ 29.99
$ 21.00
PostgreSQL 9.0 High Performance Book Cover
PostgreSQL 9.0 High Performance
$ 29.99
$ 21.00
PostgreSQL Server Programming Book Cover
PostgreSQL Server Programming
$ 29.99
$ 6.00
PostgreSQL Replication Book Cover
PostgreSQL Replication
$ 29.99
$ 21.00
ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET Book Cover
ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET
$ 29.99
$ 21.00
Oracle 10g/11g Data and Database Management Utilities Book Cover
Oracle 10g/11g Data and Database Management Utilities
$ 29.99
$ 21.00