22,79 €
Mehr erfahren.
- Herausgeber: Packt Publishing
- Kategorie: Fachliteratur
- Sprache: Englisch
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!
Das E-Book können Sie in Legimi-Apps oder einer beliebigen App lesen, die das folgende Format unterstützen:
Seitenzahl: 68
Veröffentlichungsjahr: 2013
Ähnliche
Table of Contents
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 day. This database, he says, is proof that PostgreSQL is ready for the big time.
He has great hopes for PostgreSQL as it continues to break new ground and make history.
About the Reviewers
Peter Eisentraut is a member of the core team of the PostgreSQL project and has over a decade of experience in developing and operating PostgreSQL applications. He is also active in Debian and other open source projects.
Robert Treat has been building database-backed, Internet-oriented systems for over a decade. A long time developer, user, and advocate for open source technologies, he has contributed to dozens of open source projects over the years, and has been recognized as a major contributor to the PostgreSQL project. An international speaker on open source, databases, and web operations, he spends his days as COO at OmniTI, a consultancy focused on developing and managing web systems at scale.
www.PacktPub.com
Support files, eBooks, discount offers and more
You might want to visit www.PacktPub.com for support files and downloads related to your book.
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at <[email protected]> for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
http://PacktLib.PacktPub.com
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books.
Why Subscribe?
Free Access for Packt account holders
If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.
Preface
Welcome toInstant PostgreSQL Backup and Restore How-to! These days, database-driven websites and applications are everywhere. Thanks to its free and open nature, and in no small part due to its full ACID guarantees, PostgreSQL is now a popular RDBMS used to fill the role of data storage in these next-generation apps. But with great power comes great responsibility. For a conscientious DBA, that means robust and sometimes numerous backups.
That's where we come in. PostgreSQL supplies a good toolset and documentation for securing your data from catastrophic loss. But this documentation is meant to be exhaustive, covering every known variant of using the backup tools. In a hurry? A new PostgreSQL DBA? Wading through all of that information might be overwhelming. It's there for long-term reference, not immediate or simple solutions.
This How-to fills the missing role of simple explanations for managing backups. We have a small recipe for each major variant of backup, and how to restore it. That's all. Just some commands you might type, and some exposition on how it works. No matter the size of your installation, something in this book should address your needs.
What this book covers
Getting a basic export gives an easy solution for small databases. All good things have a beginning. Export your entire database installation with a single command. Compress it and save it for later.
Partial database exports covers the tools that offer finer-grained control over what data you receive, making data migrations and copies possible. Larger databases are often backed up piece by piece.
Restoring a database export, combined with the previous recipe, has a complete solution for backup management. What to do with the backups you've made so far, and how to import them quickly is taken care of by backup management.
Obtaining a binary backup will cover the easiest way to get an exact copy of the database files for things such as warm or hot standby, or streaming replication, and open up several new possibilities. More complex systems need that copy of the database.
Stepping into TAR backups
