E-book details

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. A step-by-step guide to backing up and restoring your database using safe, efficient, and proven recipes

PostgreSQL, Shaun Thomas

Ebook
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!
  • Instant PostgreSQL Backup and Restore How-to
    • Instant PostgreSQL Backup and Restore How-to
    • Credits
    • About the Author
    • About the Reviewers
    • www.PacktPub.com
      • Support files, eBooks, discount offers and more
        • Why Subscribe?
        • Free Access for Packt account holders
    • Preface
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Errata
        • Piracy
        • Questions
    • 1. Instant PostgreSQL Backup and Restore How-to
      • Getting a basic export (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • Theres more...
          • Restoring the export
          • Exporting global objects
          • Compressed backups
          • Naming backups
      • Partial database exports (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Compressed exports
          • Table-only exports
          • Schema-only exports
          • Data and schema-only exports
      • Restoring a database export (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Parallel database restore
          • Database targeting
          • Partial database restores
      • Obtaining a binary backup (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Viewing backup progress
          • Compressed tape archive backups
          • Making the backup standalone
          • Database clones
          • Parallel compression
      • Stepping into TAR backups (Intermediate)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Parallel compression
          • Making a tar backup standby-ready
          • Backing up tablespaces
          • Backing up archived transaction logs
      • Taking snapshots (Advanced)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Proper snapshot sizing
          • Snapshot backup targets
      • Synchronizing backup servers (Intermediate)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Speeding up rsync
          • Whole file sync
          • Exclude transaction logs
      • Restoring a binary backup (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • No extract for rsync backups
          • Remote data copies
      • Point in time recovery (Intermediate)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Named restore points
          • Timelines
      • Warm and hot standby restore (Intermediate)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Trigger a backup online
          • Backup database promotion
          • Hot standby
          • Asynchronous archival
      • Streaming replication (Advanced)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Synchronous backup
          • Synchronous backup caveates
          • Streaming backups
  • Title: 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
  • Author: PostgreSQL, Shaun Thomas
  • Original title: 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
  • ISBN: 9781782169116, 9781782169116
  • Date of issue: 2013-03-26
  • Format: Ebook
  • Item ID: e_3b65
  • Publisher: Packt Publishing