Instant PostgreSQL Backup and Restore How-to
By Shaun Thomas
()
About this ebook
Related to Instant PostgreSQL Backup and Restore How-to
Related ebooks
PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance Rating: 3 out of 5 stars3/5PostgreSQL 11 Administration Cookbook: Over 175 recipes for database administrators to manage enterprise databases Rating: 0 out of 5 stars0 ratingsPostgreSQL Administration Essentials Rating: 0 out of 5 stars0 ratingsPostgreSQL 9 Administration Cookbook: LITE Edition Rating: 3 out of 5 stars3/5Troubleshooting PostgreSQL Rating: 5 out of 5 stars5/5Instant Oracle GoldenGate Rating: 0 out of 5 stars0 ratingsPostgreSQL for Data Architects Rating: 0 out of 5 stars0 ratingsPostgreSQL for Jobseekers: Introduction to PostgreSQL administration for modern DBAs (English Edition) Rating: 0 out of 5 stars0 ratingsMastering PostgreSQL 9.6 Rating: 0 out of 5 stars0 ratingsPostgreSQL 9 Administration Cookbook - Second Edition Rating: 0 out of 5 stars0 ratingsPostgreSQL 9 High Availability Cookbook Rating: 5 out of 5 stars5/5PostgreSQL Administration Cookbook, 9.5/9.6 Edition Rating: 0 out of 5 stars0 ratingsLearning ELK Stack Rating: 0 out of 5 stars0 ratingsInstant Pentaho Data Integration Kitchen Rating: 0 out of 5 stars0 ratingsOracle Database 12c Backup and Recovery Survival Guide Rating: 5 out of 5 stars5/5Oracle: Protect Your Data Rating: 0 out of 5 stars0 ratingsAdvanced Platform Development with Kubernetes: Enabling Data Management, the Internet of Things, Blockchain, and Machine Learning Rating: 0 out of 5 stars0 ratingsOracle 11g Streams Implementer's Guide Rating: 0 out of 5 stars0 ratingsMySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users Rating: 4 out of 5 stars4/5Oracle Exalytics Revealed: E-Book Rating: 0 out of 5 stars0 ratingsUnderstanding Azure Data Factory: Operationalizing Big Data and Advanced Analytics Solutions Rating: 0 out of 5 stars0 ratingsPostgreSQL Server Programming - Second Edition Rating: 0 out of 5 stars0 ratingsPractical Oracle Cloud Infrastructure: Infrastructure as a Service, Autonomous Database, Managed Kubernetes, and Serverless Rating: 0 out of 5 stars0 ratingsLearn Hadoop in 24 Hours Rating: 0 out of 5 stars0 ratingsOracle GoldenGate 12c Implementer's Guide Rating: 0 out of 5 stars0 ratingsPostgreSQL High Performance Cookbook Rating: 0 out of 5 stars0 ratingsOracle Ultimate DBA Interview Questions Rating: 5 out of 5 stars5/5Oracle Database 12c Security Cookbook Rating: 0 out of 5 stars0 ratingsMySQL Admin Cookbook LITE: Replication and Indexing Rating: 4 out of 5 stars4/5Introduction to Oracle Database Administration Rating: 5 out of 5 stars5/5
System Administration For You
Cybersecurity: The Beginner's Guide: A comprehensive guide to getting started in cybersecurity Rating: 5 out of 5 stars5/5Wordpress 2023 A Beginners Guide : Design Your Own Website With WordPress 2023 Rating: 0 out of 5 stars0 ratingsLinux Command-Line Tips & Tricks Rating: 0 out of 5 stars0 ratingsThe Complete Powershell Training for Beginners Rating: 0 out of 5 stars0 ratingsLinux Bible Rating: 0 out of 5 stars0 ratingsLearn PowerShell in a Month of Lunches, Fourth Edition: Covers Windows, Linux, and macOS Rating: 5 out of 5 stars5/5CompTIA A+ Complete Review Guide: Core 1 Exam 220-1101 and Core 2 Exam 220-1102 Rating: 5 out of 5 stars5/5Linux: Learn in 24 Hours Rating: 5 out of 5 stars5/5PowerShell: A Beginner's Guide to Windows PowerShell Rating: 4 out of 5 stars4/5Practical Data Analysis Rating: 4 out of 5 stars4/5Networking for System Administrators: IT Mastery, #5 Rating: 5 out of 5 stars5/5Bash Command Line Pro Tips Rating: 5 out of 5 stars5/5Mastering Salesforce CRM Administration Rating: 5 out of 5 stars5/5PowerShell: A Comprehensive Guide to Windows PowerShell Rating: 4 out of 5 stars4/5Mastering Windows PowerShell Scripting Rating: 4 out of 5 stars4/5Mastering Ubuntu Server Rating: 5 out of 5 stars5/5Ethical Hacking Rating: 4 out of 5 stars4/5Linux Commands By Example Rating: 5 out of 5 stars5/5ServiceNow IT Operations Management Rating: 5 out of 5 stars5/5Rocky Linux 9 Essentials: Learn to Install, Administer, and Deploy Rocky Linux 9 Systems Rating: 0 out of 5 stars0 ratingsLearn Windows PowerShell in a Month of Lunches Rating: 0 out of 5 stars0 ratingsOperating Systems DeMYSTiFieD Rating: 0 out of 5 stars0 ratingsLinux for Beginners: Linux Command Line, Linux Programming and Linux Operating System Rating: 4 out of 5 stars4/5Git Essentials Rating: 4 out of 5 stars4/5RHCSA Exam Pass: Red Hat Certified System Administrator Study Guide Rating: 0 out of 5 stars0 ratingsLearning Microsoft Endpoint Manager: Unified Endpoint Management with Intune and the Enterprise Mobility + Security Suite Rating: 0 out of 5 stars0 ratings
Reviews for Instant PostgreSQL Backup and Restore How-to
0 ratings0 reviews
Book preview
Instant PostgreSQL Backup and Restore How-to - Shaun Thomas
Table of Contents
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...
There's 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
Instant PostgreSQL Backup and Restore How-to
Instant PostgreSQL Backup and Restore How-to
Copyright © 2013 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: March 2013
Production Reference: 1200313
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78216-910-9
www.packtpub.com
Credits
Author
Shaun M. Thomas
Reviewers
Peter Eisentraut
Robert H. Treat
Acquisition Editor
Martin Bell
Commissioning Editor
Yogesh Dalvi
Technical Editor
Veena Pagare
Copy Editor
Laxmi Subramanian
Project Coordinator
Sneha Modi
Proofreader
Maria Gould
Production Coordinator
Melwyn D'sa
Cover Work
Melwyn D'sa
Cover Image
Sheetal Aute
About the Author
Shaun M. Thomas has been a database administrator for a long time, and has been working with PostgreSQL since late 2000. Over the years, he has contributed frequently to the PostgreSQL performance mailing list to help other DBAs get the most out of his favorite database. In 2011 and 2012, he presented at the Postgres Open conference on topics such as handling extreme throughput, high availability, server redundancy, and failover techniques.
Currently, he serves as the database architect at OptionsHouse, an online options brokerage with a PostgreSQL database that handles over one billion queries per