Book Image

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake
Book Image

Learning Heroku Postgres

By: Patrick Rafael de Oliveira Espake

Overview of this book

Table of Contents (17 chapters)
Learning Heroku Postgres
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Keyword List
Index

Chapter 4. PG Backups

Backups are important at any level. Failures are possible to occur at any system that uses the database. It may be an accidental failure, data corruption, or hardware-related. You need to perform actions anticipating failures and take steps to ensure data integrity. Therefore, Heroku offers an add-on called PG Backups that allows you to create and restore backups of your Postgres database hosted on Heroku, and also to import and export data.

In this chapter, you will learn how to use the features that this add-on provides.

This chapter will cover the following topics:

  • Plans

  • Installing the add-on

  • Changing the plan

  • Creating a backup

  • Listing backups

  • Downloading a backup

  • Deleting backups

  • Restoring from a backup

  • Importing databases

  • Exporting databases

  • Removing the add-on