Have a personal or library account? Click to login
Instant PostgreSQL Backup and Restore How-to Cover

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

Publisher:Packt Publishing Limited
Paid access
|Apr 2013
Product purchase options

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

Key Features

  • 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

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!

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

Who this book is for

Written for database administrators who want to create backups of their critical enterprise data and efficiently restore it using PostgreSQL.

Table of Contents

    PDF ISBN: 978-1-78216-911-6
    Publisher: Packt Publishing Limited
    Copyright owner: © 2013 Packt Publishing Limited
    Publication date: 2013
    Language: English
    Pages: 54
    Related subjects:
    Computer sciences,
    Computer sciences, other

    People also read

    PostgreSQL Administration Cookbook, 9.5/9.6 Edition
    Book

    PostgreSQL Administration Cookbook, 9.5/9.6 Edition

    PostgreSQL 9 Administration Cookbook - Second Edition
    Book

    PostgreSQL 9 Administration Cookbook - Second Edition

    PostgreSQL Replication, Second Edition
    Book
    New

    PostgreSQL Replication, Second Edition

    PostgreSQL Administration Essentials
    Book
    New

    PostgreSQL Administration Essentials

    PostgreSQL 15 Cookbook
    Book

    PostgreSQL 15 Cookbook

    Samsad Hussain, Mohammad
    Mastering PostgreSQL 9.6
    Book
    New

    Mastering PostgreSQL 9.6

    Schönig, Hans-Jürgen
    PostgreSQL 9 High Availability Cookbook
    Book
    New

    PostgreSQL 9 High Availability Cookbook

    Thomas, Shaun
    PostgreSQL 11 Administration Cookbook
    Book

    PostgreSQL 11 Administration Cookbook

    Riggs, Simon, Ciolli, Gianni, Meesala, Sudheer Kumar
    PostgreSQL 10 Administration Cookbook
    Book

    PostgreSQL 10 Administration Cookbook

    PostgreSQL High Availability Cookbook
    Book
    New

    PostgreSQL High Availability Cookbook

    Thomas, Shaun