Database Reference
In-Depth Information
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. There-
fore, 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
